| From: | James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us> |
|---|---|
| To: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] can a column be aliased? |
| Date: | 1998-08-04 12:26:16 |
| Message-ID: | 81Aug3.071531edt.35713@gateway.lee.k12.nc.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> I don't think so. Better use a sequence instead. You shouldn't be
> using OID as a key anyway. You lose the value if you dump and reload.
>
Ah...there's the rub. Well, I haven't been doing that anyway; I was merely trying
to explore the possiblity of doing so after I heard some users ask about it. At
first thought I had the reservation of it not being portable, but with your
thought (they change after a dump and reload) I can see that's a _real_ bad idea.
Thanks...james
> --
> D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
> http://www.druid.net/darcy/ | and a sheep voting on
> +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Williams | 1998-08-04 13:44:48 | Which index is better for join operations |
| Previous Message | D'Arcy J.M. Cain | 1998-08-04 11:38:08 | Re: [SQL] can a column be aliased? |