Re: [GENERAL] Should I upgrade Postgres?

On Tue, 5 Jan 1999, David Hartwig wrote: > For more features, better performance, and better support - upgrade. Amd better stability... > > [EMAIL PROTECTED] wrote: > > > I just installed postgres 6.1.1 on Caldera 1.3 (it came with it). > > Should I upgrade this immediately or is this good e

Re: [GENERAL] Should I upgrade Postgres?

On Tue, 5 Jan 1999 [EMAIL PROTECTED] wrote: > I just installed postgres 6.1.1 on Caldera 1.3 (it came with it). > Should I upgrade this immediately or is this good enough for now? > If so, which version should I upgrade to 6.3.x or 6.4.x? UPgrade to v6.4.2 before you do anyting else withthat mac

Re: [GENERAL] Should I upgrade Postgres?

For more features, better performance, and better support - upgrade. [EMAIL PROTECTED] wrote: > I just installed postgres 6.1.1 on Caldera 1.3 (it came with it). > Should I upgrade this immediately or is this good enough for now? > If so, which version should I upgrade to 6.3.x or 6.4.x? > > Tha

[GENERAL] Views

How can I see a view in psql after having created it? If I enter \d I can see the fields, but how can I see what makes up the view? Best if the original CREATE statement could be listed somehow.

Re: [GENERAL] select using date

> Trying to use select statement using CURRENT_DATE > Which works fine like so: > > select * from headlines where dateof = CURRENT_DATE order by dateof desc > > But I'm also wanting to do something similar to: > > select * from headlines where dateof = CURRENT_DATE - INTERVAL '1' DAY > order by

[GENERAL] Should I upgrade Postgres?

I just installed postgres 6.1.1 on Caldera 1.3 (it came with it). Should I upgrade this immediately or is this good enough for now? If so, which version should I upgrade to 6.3.x or 6.4.x? Thanks, -- matthew rice, starnix inc.

[GENERAL] select using date

Trying to use select statement using CURRENT_DATE Which works fine like so: select * from headlines where dateof = CURRENT_DATE order by dateof desc But I'm also wanting to do something similar to: select * from headlines where dateof = CURRENT_DATE - INTERVAL '1' DAY order by dateof desc B

Re: [GENERAL] Triggers and sql functions not working...

> "GY" == Greg Youngblood <[EMAIL PROTECTED]> writes: . . . GY> create function update_tab2 () returns int4 as 'insert into tab2 (l,a,g) GY> select distinct a.l,b.a,b.c from tab2 a,tab1 b where b.a not in (select GY> distinct a from tab2); select 1 as exitvalue;' language 'sql'; . . .