Skip site navigation (1) Skip section navigation (2)

From: Manish Vig <sk(at)pobox(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Date: 2000-11-30 10:51:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Dear Sir,
thanks for the reply.
I tried                     select now()
but it gives   the following error
syntax error near unexpected token `select.

To be specific about  my problem, I want to compare one max date with the
current date in my Java servlet
Since nested  queries are not possible, how do i acheive my goal.

My present query doesn't  works and is like this

Select months_between(('select max(h_date ) from query where
email="hawks(at)vsnl(dot)com"),(select sysdate from dual)) from query

What is the SQL query that can acheive the same effect.
With Best Regards


  • Re: at 2000-11-30 13:38:32 from Michael Fork

pgsql-hackers by date

Next:From: mlwDate: 2000-11-30 12:26:27
Subject: Odd select behavior -- statistics, redux (7.0.x and devel)
Previous:From: Thomas LockhartDate: 2000-11-30 05:24:14
Subject: Re: Please advise features in 7.1 (SUMMARY)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group