Re: [HACKERS] comparison operators

2014-06-18 Thread Stephen Frost
* Andrew Dunstan (and...@dunslane.net) wrote: I think I'd rather just say for many data types or something along those lines, rather than imply that there is some obvious rule that users should be able to intuit. Perhaps with a link to where the informaiton about which exist is available..?

Re: [HACKERS] comparison operators

2014-06-18 Thread Tom Lane
Stephen Frost sfr...@snowman.net writes: * Andrew Dunstan (and...@dunslane.net) wrote: I think I'd rather just say for many data types or something along those lines, rather than imply that there is some obvious rule that users should be able to intuit. Perhaps with a link to where the

Re: [HACKERS] comparison operators

2014-06-18 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: Stephen Frost sfr...@snowman.net writes: * Andrew Dunstan (and...@dunslane.net) wrote: I think I'd rather just say for many data types or something along those lines, rather than imply that there is some obvious rule that users should be able to

Re: [HACKERS] comparison operators

2014-06-18 Thread David G Johnston
Andrew Dunstan wrote On 06/17/2014 07:25 PM, Andres Freund wrote: On 2014-06-17 19:22:07 -0400, Tom Lane wrote: Andrew Dunstan lt; andrew@ gt; writes: I went to have a look at documenting the jsonb comparison operators, and found that the docs on comparison operators contain this:

Re: [HACKERS] comparison operators

2014-06-18 Thread Tom Lane
David G Johnston david.g.johns...@gmail.com writes: Andrew Dunstan wrote I think I'd rather just say for many data types or something along those lines, rather than imply that there is some obvious rule that users should be able to intuit. Ideal world for me: we'd list the data types that

[HACKERS] comparison operators

2014-06-17 Thread Andrew Dunstan
I went to have a look at documenting the jsonb comparison operators, and found that the docs on comparison operators contain this: Comparison operators are available for all relevant data types. They neglect to specify further, however. This doesn't seem very satisfactory. How is a user

Re: [HACKERS] comparison operators

2014-06-17 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I went to have a look at documenting the jsonb comparison operators, and found that the docs on comparison operators contain this: Comparison operators are available for all relevant data types. They neglect to specify further, however. This

Re: [HACKERS] comparison operators

2014-06-17 Thread Andres Freund
On 2014-06-17 19:22:07 -0400, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: I went to have a look at documenting the jsonb comparison operators, and found that the docs on comparison operators contain this: Comparison operators are available for all relevant data types.

Re: [HACKERS] comparison operators

2014-06-17 Thread Andrew Dunstan
On 06/17/2014 07:25 PM, Andres Freund wrote: On 2014-06-17 19:22:07 -0400, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: I went to have a look at documenting the jsonb comparison operators, and found that the docs on comparison operators contain this: Comparison operators

[HACKERS] Comparison operators for bytea

2001-02-04 Thread Christopher Kings-Lynne
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