[BUGS] libpq.a must be ranlibed after installation
Libpq.a still not ranlibed after installation. It causes link error on some platform likes as Mac OS X for PostgreSQL 7.3.3. Kenji Sugita ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] Cast possible only throught a function
Hi all, running on Postgres 7.3.3 I seen that cast a integer to an intervall is not permitted select 0::interval;<- give error but select 0::text::interval; <- works fine but I notice that the following function return correctly doing the integer -> interval cast in one "shot": create or replace function foo() returns interval as ' declare begin return 0; end; ' language 'plpgsql'; this implicit cast could not be source of issue ? Gaetano ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [BUGS] libpq.a must be ranlibed after installation
Kenji Sugita <[EMAIL PROTECTED]> writes: > Libpq.a still not ranlibed after installation. It causes link error on some > platform likes as Mac OS X for PostgreSQL 7.3.3. I see no problem when I test on OS X. Please exhibit a test case ... regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [BUGS] Cast possible only throught a function
"Mendola Gaetano" <[EMAIL PROTECTED]> writes: > but I notice that the following function return correctly > doing the integer -> interval cast in one "shot": What plpgsql is doing is roughly comparable to regression=# select '0'::interval; interval -- 00:00:00 (1 row) This is not the same as a SQL type conversion --- that works only when a cast function is defined in pg_cast. plpgsql is pretty lax about datatype considerations. It is willing to try to convert anything to anything else by running the first type's output procedure (to get text) and then the second type's input procedure. In straight SQL you'd have to specify a cast to text to get the equivalent behavior. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [BUGS] libpq.a must be ranlibed after installation
I have see this problem since 7.3.1 Ted --- Tom Lane <[EMAIL PROTECTED]> wrote: > Kenji Sugita <[EMAIL PROTECTED]> writes: > > Libpq.a still not ranlibed after installation. It > causes link error on some > > platform likes as Mac OS X for PostgreSQL 7.3.3. > > I see no problem when I test on OS X. Please > exhibit a test case ... > > regards, tom lane > > ---(end of > broadcast)--- > TIP 8: explain analyze is your friend __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
