James G Wilkinson <[EMAIL PROTECTED]> writes:
> beta_jgw=# update scenario1.time_test set local_day = extract(day from
> to_timestamp(to_char(gmt_date,'-MM-DD')||'
> '||to_char(gmt_hour,'99')||':00:00-00','-MM-DD HH24:MI:SS') at time
> zone 'EST');
That seems like a mighty ugly way to d
Mauro Bertoli wrote:
> Hi,
> I've installed a Postgres 8.0.
> There's a history file with all executed queries?
If you are using psql, \s will show you your old queries. From the
server side, if you enable 'log_statement' all queries will go into the
server logs.
--
Bruce Momjian
Hi,
I've installed a Postgres 8.0.
There's a history file with all executed queries?
Thanks!
___
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam,
Giochi, Rubrica
Scaricalo ora!
http://it.messenger.yahoo.it
hullo all,
I have a problem with a table containing a lot of data.
referred tables "inserzionista" and "pubblicazioni" (referenced 2 times)
have resp. 1909 tuples and 8300 tuples, while this one 54942.
now the problem is that it is slow, also a simple "select * from
pubblicita". (it takes 5-6 se
I hope that this is some silly beginner's mistake. I have spent quite a
bit of time
reading the PostgreSQL documentation and cannot find my error. I have also
scanned the PostgreSQL archive and the web for help, but I have not
found anything
to get me over the hump (it is probably out there, I
hi,
I want to know is there any way to execute an anonymous PL/pgSQL block
in PostgreSQL.
Thanx
--
Regards
Imad
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
