Thread
-
A mistake generates strange result
Ricardo J.C.Coelho <pulsar@truenet-ce.com.br> — 1999-02-08T22:21:11Z
Just for PgSQL's development group think about.... I made a mistake typing a query that generates a strange result (Very strange). The query: select text('12345678'::float8); It returns a date in datetime format !!!!!! If you use: select ('12345678'::float8)::text; everything runs well. -
How do I unsubscribe?
Joel Parker Henderson <joel@school.net> — 1999-02-09T01:57:03Z
How do I unsubscribe? Sorry to post this to the entire list, but it your messages don't have unsubscription info at the bottom, and the person who subscribed (ckhui@school.net) isn't a valid user here (I am the postmaster). -Joel Henderson postmaster@school.net
-
Using As with Inheritance?
Clark C. Evans <clark.evans@manhattanproject.com> — 1999-02-09T04:40:06Z
I have a parallel inheritance going on, so I was wondering if there was a way to re-name a derived column? This would make my design clearer. ----------------- CREATE TABLE B ( NAME VARCHAR(10) ); CREATE TABLE C ( ... ) INHERITS(B); CREATE TABLE X ( A VARCHAR(10), B VARCHAR(10), CONSTRAINT FOREIGN KEY (B) REFERENCES B(OID) ); CREATE TABLE Y ( B AS C, /* Syntatic Sugar */ D VARCHAR(10), CONSTRAINT FOREIGN KEY (C) REFERENCES C(OID) ) INHERITS(X) Here, I've added the syntax "AS" to show that column A in table X, is called B in the derived table Y. Thank you for your thoughts. :) Clark Evans
-
Re: [GENERAL] A mistake generates strange result
Stéphane Dupille <sdupille@i-france.com> — 1999-02-09T08:55:23Z
Hi ! "Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br> writes: > Just for PgSQL's development group think about.... > I made a mistake typing a query that generates a strange result > (Very strange). > The query: select text('12345678'::float8); > It returns a date in datetime format !!!!!! I didn't found any function of name "text" that converts float8 to text. So I think Postgres made an implicit cast of the data to datatime. So: String->Float8->DateTime->Text. Stranger : I didn't found any function to cinvert float to text ! > If you use: select ('12345678'::float8)::text; everything runs well. Here, you made an explicit cast, without the use of any function. So your data is casted well. Hope this helps ! -
Re: [GENERAL] A mistake generates strange result
Postgres DBA <postgres@nest.bistbn.com> — 1999-02-10T13:31:01Z
Unfortunately, that is true, at least for Postgres 6.4.0: template1=> select text('12345678'::float8); text ----------------------------- Tue May 23 00:21:18 2000 EEST (1 row) Please, guys, take care of this small bug:-) Aleksey On 9 Feb 1999, [ISO-8859-1] Stphane Dupille wrote: > > Hi ! > > "Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br> writes: > > Just for PgSQL's development group think about.... > > I made a mistake typing a query that generates a strange result > > (Very strange). > > > The query: select text('12345678'::float8); > > It returns a date in datetime format !!!!!! > > I didn't found any function of name "text" that converts > float8 to text. So I think Postgres made an implicit cast of the data > to datatime. So: String->Float8->DateTime->Text. Stranger : I didn't > found any function to cinvert float to text ! > > > If you use: select ('12345678'::float8)::text; everything runs well. > > Here, you made an explicit cast, without the use of any > function. So your data is casted well. > > Hope this helps ! > > -
Re: [HACKERS] Re: [GENERAL] A mistake generates strange result
Bruce Momjian <maillist@candle.pha.pa.us> — 1999-02-10T15:25:44Z
> > Unfortunately, that is true, at least for Postgres 6.4.0: > template1=> select text('12345678'::float8); > > text > ----------------------------- > Tue May 23 00:21:18 2000 EEST > (1 row) > > Please, guys, take care of this small bug:-) > Aleksey Works in the current tree: test=> select text('12345678'::float8); text -------- 12345678 (1 row) test=> -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 -
Re: [HACKERS] Re: [GENERAL] A mistake generates strange result
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1999-02-10T15:26:49Z
> Unfortunately, that is true, at least for Postgres 6.4.0: > template1=> select text('12345678'::float8); > ----------------------------- > Tue May 23 00:21:18 2000 EEST > Please, guys, take care of this small bug:-) tgl=> select text('12345678'::float8); text -------- 12345678 (1 row) Already done. From the cvs log: revision 1.84 date: 1998/11/17 14:36:51; author: thomas; state: Exp; lines: +34 -15 Add text<->float8 and text<->float4 conversion functions. This will fix the problem reported by Jose' Soares when trying to cast a float to text. - Tom -
Re: [GENERAL] A mistake generates strange result
jose' soares <sferac@bo.nettuno.it> — 1999-02-12T14:06:50Z
Stéphane Dupille ha scritto: > Hi ! > > "Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br> writes: > > Just for PgSQL's development group think about.... > > I made a mistake typing a query that generates a strange result > > (Very strange). > > > The query: select text('12345678'::float8); > > It returns a date in datetime format !!!!!! > > I didn't found any function of name "text" that converts > float8 to text. So I think Postgres made an implicit cast of the data > to datatime. So: String->Float8->DateTime->Text. Stranger : I didn't > found any function to cinvert float to text ! > > > If you use: select ('12345678'::float8)::text; everything runs well. > > Here, you made an explicit cast, without the use of any > function. So your data is casted well. > > Hope this helps ! This seems like a bug, because there's no a text(float8) built-in function. hygea=> select text('12345678'::float8); text ---------------------- 2000-05-22 23:21:18+02 but if you create the function like: create function text(float8) returns text as ' begin return $1; end; ' language 'plpgsql'; CREATE select text('12345678.2'::float8); text ---------- 12345678.2 (1 row) - Jose' - And behold, I tell you these things that ye may learn wisdom; that ye may learn that when ye are in the service of your fellow beings ye are only in the service of your God. - Mosiah 2:17 -