Re: at time zone question in pl/pgSQL

> I'm trying to write a simple pl/pgsql function that will return the
current time for the given time zone ( i have to deal multiple time zones) .
But I don't seem to be using the appropriate syntax.   I keep getting an
error on the 'at time zone...'

> DECLARE
>   new_time TIMESTAMP;
> BEGIN
>    SELECT INTO new_time now() at time zone 'PST';   /*just hard coding the
time zone for now */
>   return new_time;
> END;

Assuming that this is a direct cut and paste, the error would appear to be
that the single quotes around the timezone are not escaped. Try changing
that line to:

   SELECT INTO new_time now() at time zone ''PST'';   /*just hard coding the
time zone for now */

If that's not it, nevermind :)

Greg