Re: SELECT EXTRACT doesn't work with variables?

From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: miércoles, 18 de diciembre de 2002 17:00
To: Masaru Sugawara
Cc: cmarin(at)dims(dot)com; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] SELECT EXTRACT doesn't work with variables?

Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp> writes:
> Conxita Marín <comarin(at)telefonica(dot)net> wrote:
>> aux2 = SELECT EXTRACT(EPOCH FROM TIMESTAMP aux);

> Instead of this line, I think you need to execute the following statement:

> SELECT INTO aux2 EXTRACT(EPOCH FROM aux);

Or

aux2 = EXTRACT(EPOCH FROM TIMESTAMP aux);

This works: SELECT INTO aux2 EXTRACT(EPOCH FROM aux);

This doesn't work: aux2 = EXTRACT(EPOCH FROM TIMESTAMP aux);

NOTICE: Error occurred while executing PL/pgSQL function prova
NOTICE: line 9 at assignment
ERROR: parser: parse error at or near "$1"

Thanks to all.

Conxita.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?