select extract and subqueries

From: "mike sears" <matrix(at)quadrent(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: select extract and subqueries
Date: 2001-11-21 02:12:31
Message-ID: 001f01c17233$6e0d0490$fa00000a@wyd2002.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I don't know if its possiable or not but I've been having problems trying to extract the timestamp out of one of my columns so that I can compare the dates.

if I do the following it gives me a proper epoch
en=# SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-11-20');
date_part
------------
1006232400
(1 row)

but if I try to use a subquery to get the date it gives me a parse error.

en=# SELECT EXTRACT (EPOCH FROM TIMESTAMP (select date from master));
ERROR: parser: parse error at or near "select"

is this simply just a limitation of the extract funtion or am I missing something?

Mike

Browse pgsql-general by date

  From Date Subject
Next Message mike sears 2001-11-21 02:34:02 select extract and subqueries
Previous Message Jason Earl 2001-11-21 01:34:56 Re: migrating from MSSql