Hi all,
I'm sure I found somewhere in the docs, that postgreSQL 7.0 accepts ANSI-SQL style
join syntax, but when I try:
SELECT ta.a, tb.b FROM taba ta INNER JOIN tabb tb ON ta.c = tb.c;
I get the strange message:
ERROR: transformExpr: does not know how to transform node 501 (internal error)
"Gary J. Farmer" <[EMAIL PROTECTED]> writes:
> >> I think the order thing will work though I have no choice of using
> >> numbering for the address_type as I am working off a pre-existing
> >> database. They are using a mnemonic char type. I am essentially batch
> >> downloading and processin
Are there anywhere to configure so that whenever I call 'psql dbname',
it'll always prompt for user authentication instead of getting into the
database directly?
In addition, I'd like to default various database settings when I
connect to the database. Where is the place to do such configuration?
>> I think the order thing will work though I have no choice of using
>> numbering for the address_type as I am working off a pre-existing
>> database. They are using a mnemonic char type. I am essentially batch
>> downloading and processing this and other database tables for query
>> and pre
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> The immediate cause of this gripe was discussed just a day or so ago
>> on one or another of the pgsql lists. The timestamp-to-date conversion
>> routine has this weird idea that it should kick out an error instead
>> of returning NULL when presented
Philip Warner <[EMAIL PROTECTED]> writes:
> At 02:26 17/07/00 -0400, Tom Lane wrote:
>> Well before my time, I guess --- as long as I've been paying attention,
>> the function manager's approach was to call the routine first and *then*
>> insert a NULL result ... if the routine hadn't crashed firs
