I am in the process of converting an old system to a
new system where I have chosen to use postgres in
stead of a home grow system based on b-trees.
The system receives 2650 message a total of 10Mbytes
of data per 15 minutes this information have to be
store in 4 tables in the database. Some of
Hi,
It looks as if psql has internal variables I am how
ever not able to get it to work in the way I want.
I need to store the current date and then delete all
elements from 3 tables based on the same date.
I tried to set the variable curtime:
set curtime now()
but I could not use it in a
Hi,
I am new to postgres sql and have a problem with an
sql statement which I hope you can help me with.
I want to do some calculation on the result of a
query.
I have a table tb_test which contains a timestamp
column my_timestamp.
My sql statement should display my_timestamp as 00,
20, 40
