On 23/3/06 23:43, "Tony Caduto" <[EMAIL PROTECTED]> wrote:
> Peter Eisentraut wrote:
>> There has never been a type named double in PostgreSQL. The type name
>> mandated by the SQL standard is double precision, and PostgreSQL
>> supports that.
>>
>>
> Ok, Thanks for clearing that up for me :-)
>
> Maybe it was pgAdmin that did the substitution.
Nope, must have been you. Why would you have been using pgAdmin anyway? :-p
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match