Hi Rob,
Try this:
select * from blah where stamp >= now()::date - 7;
I think it should work.
/Patrik Kudo
On Mon, 10 Jul 2000, Rob S. wrote:
> Hi all,
>
> I would like to say,
>
> "select * from blah where stamp >= 7 days ago"
>
> ...where the "days ago" is calculated at query time; meani
Hi,
Is there SQL-92 SQLSTATE or SQL-96 SQLCODE implemented
in
PostgreSQL (I use version 7.0 on SuSe Linux 6.4)
?
If so, how to take the value of it in stored
procedures (written in PL/pgSQL or C)
In documentation I found only a short describtion of
sqlca
In ecpg.
Thanks in advance
Adam
Hello,
Is it possible to check for the existence of a table within PL/pgSQL?
Would
select count(*) from pg_class where relname='name' and
reltype='0'
be the answer to this question?
--
Paul McGarrymailto:[EMAIL PROTECTED]
Systems Integrator http://www.opentec.com.au
Opente
Hello,
how can I change the type of a column, e.g. from varchar() to text?
Or is it possible to drop (i.e. delete) a column without
creating a new table from the old one but without that column,
dropping the old table and renaming the old to the new?
Thanks,
Volker Paul
> Does Postgresql support only EUC? Basically, I am trying to save
> international
> fonts to Postgresql, so I'm trying to find out what exactly I need to do.
I'd suggest you try the Unicode UTF-8 encoding. It supports many
languages, including Japanese of course, and needs no modification
of ex
I think this is in the FAQ. I was reading it last nite and I believe
there's something in there that might be relevant.
- r
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Volker Paul
> Sent: July 11, 2000 12:32 AM
> To: [EMAIL PROTECTED]
> Subjec
Volker,
Thank you, I was using UTF8 because I am accessing the database via
JDBC, and Java's default encoding is UTF8. I wasn't sure about whether
it was a right thing to do or not.
Thank you very much. I really appreciate your help!
Tony Nakamura
- Original Message -
From: Volker
I think you meant:
select * from blah where stamp >= now() - '7days'::interval;
You can also try:
select * from blah where age( now(), stamp ) < '7days'::interval;
Frank
At 09:07 AM 7/11/00 +0200, you wrote:
>Hi Rob,
>
>Try this:
>
>select * from blah where stamp >= now()::date - 7;
>
>I thin
My friends, you are truly life-savers. Thanks very much!
How on Earth do you know this stuff? =) I saw all of these in the User's
Guide (re: now(), interval keyword, etc.), but in no way would figure this
was how they were put together!
Aside from the few in the FAQ, is there a list of commonl
