Re: [GENERAL] btree index and max()

2000-06-01 Thread Elliot Finley
On Thu, 1 Jun 2000 19:10:48 -0300, [EMAIL PROTECTED] wrote: >> [EMAIL PROTECTED] writes: >> > I understand that the query planner cannot be so clever >> > to grasp that this particular function (max or min) >> > might be evaluated by just travelling the BTREE index. >> > Am I correct? >> >

[GENERAL] Q: Truncated output

2000-06-01 Thread Elliot Finley
I've just started using Postgres 6.5.2 and I'm trying to figure out a way to be able to see the complete 'type' for the 'employee_id' field. I can't remember which sequence I used in the 'nextval', so I need to be able to see which one is being used there. shift=> \d employee Table= employee