| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Comparison operators for bytea |
| Date: | 2001-02-05 03:14:51 |
| Message-ID: | NEBBIODEHDOLHLJPJCDDIECFCAAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I notice that in 7.0.3 there are no '<' or '>' operators defined for the
bytea type. Is this (should this be) fixed in 7.l?
It just makes it impossible to do stuff like SELECT DISTINCT (byteafield),
etc...
The reason i'm trying to do this is I have written a query that discovers
all the foreign keys in a table, (meaning I could actually modify pg_dump to
use ALTER TABLE ADD FOREIGN KEY statements instead of ADD CONSTRAINT
TRIGGER), however I need to do a DISTINCT across pg_trigger.tgargs...
Chris
--
Christopher Kings-Lynne
Family Health Network (ACN 089 639 243)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roderick A. Anderson | 2001-02-05 03:22:37 | Re: Foreign Key Columns And Indices |
| Previous Message | Christopher Kings-Lynne | 2001-02-05 03:01:47 | Foreign Key Columns And Indices |