| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Postgres 8.4 view keys |
| Date: | 2010-04-12 12:30:07 |
| Message-ID: | 20100412123007.GC20901@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
In response to Thomas Kellerer :
> A. Kretschmer, 12.04.2010 13:52:
> >In response to richard terry :
> >>I wondered if postges could some how auto-generate a unique view key?
> >
> >What do you mean with a 'unique view key'?
> >
> >I'm not sure, but maybe you are searching for SERIAL (a datatype)
>
> Or row_number()
Hey, maybe you are right ;-)
But row_number() isn't always unique: only if it works over the whole
result set and not over multiple windows.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | syan | 2010-04-13 01:19:34 | Re: slow plan on join when adding where clause |
| Previous Message | Thomas Kellerer | 2010-04-12 12:00:41 | Re: Postgres 8.4 view keys |