Skip to main content
Database Administrators
Héctor's user avatar
Héctor's user avatar
Héctor's user avatar
Héctor
  • Member for 3 years, 9 months
  • Last seen more than a month ago
  • world
Profile Activity

11 Questions

Score Activity Newest Views
3 votes
2 answers
5k views

SELECT sql_function(...) vs SELECT * FROM sql_function(...)

3 votes
1 answer
117 views

case sensivity incongruity

3 votes
1 answer
2k views

ERROR: CREATE MATERIALIZED VIEW ... WITH DATA cannot be executed from a function

2 votes
1 answer
399 views

Error while creating continuous aggregate (materialized view) when source and new time columns have the same name (PSQL/TSDB)

2 votes
1 answer
2k views

PLPGSQL store columns of a 2D query output into array variables

1 vote
1 answer
3k views

SELECT rows from table one by one, comparing one column values with values in an array

0 votes
1 answer
2k views

UPDATE column with previous value

0 votes
2 answers
670 views

Postgresql backup with ZFS snapshots: Is pg_start_backup()/pg_stop_backup() necessary?

0 votes
1 answer
111 views

postgresl.conf vs conf.d/*: which has greater precedence

0 votes
1 answer
644 views

Move timescaledb hypertable from a postgresql server to another one

0 votes
1 answer
7k views

POSTGRESQL Subtract to each row the previous row