From: | bgiles at coyotesong(dot)com (Bear Giles) |
---|---|
To: | |
Subject: | [Pljava-dev] testing for equality in user-defined types in select statements |
Date: | 2011-12-27 03:41:11 |
Message-ID: | CALBNtw6S9hkouW=m-quHw_TZD=SQi-NJKE+NCKkHOS3wh1O_1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
I have a UDT for rational numbers. I want to be able to add it in select
statements but it doesn't work.
As a really simple example consider two tables
create table foo (foo varchar(20), value rational);
create table bar (bar varchar(20), value rational);
select f.value, f.foo, b.bar from foo f join bar b on (f.value =
b.value);
I vaguely recall that there were standard function names for this when I
played with C UDT years ago but that was PSQL version 5.x or 6.x. Is that
still the case? In either case the wiki should be updated.
There should be additional functions for ordering.
Thanks,
Bear
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20111226/82e546d2/attachment.html>
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2011-12-27 04:02:48 | [Pljava-dev] testing for equality in user-defined types in select statements |
Previous Message | Hal Hildebrand | 2011-12-26 23:28:58 | [Pljava-dev] java.lang.SecurityException: read on /usr/share/javazi/UTC |