pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedALTER TABLE ( smallinto -> boolean ) ...
13+ messages / 7 participants
[nested] [flat]
* ALTER TABLE ( smallinto -> boolean ) ...
@ 2005-08-29 23:15 Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:24 ` Re: ALTER TABLE ( smallinto -> boolean ) ... David Fetter <david@fetter.org>
2005-08-29 23:33 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Rod Taylor <pg@rbt.ca>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 3 replies; 13+ messages in thread
From: Marc G. Fournier @ 2005-08-29 23:15 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
I have a table with several 'smallint' fields that I'd like to convert to
booleean ... the data in each is either 0 or 1, and:
# select '1'::boolean;
bool
------
t
(1 row)
# select '0'::boolean;
bool
------
f
(1 row)
so they do cast as expected ... but, if I try to do the ALTER, I get:
# ALTER TABLE table ALTER COLUMN field1 type boolean;
ERROR: column "field1" cannot be cast to type "pg_catalog.bool"
Should this not work? If not, is there a way to do it so that it will,
without having to reload the whole table?
Thanks ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
@ 2005-08-29 23:24 ` David Fetter <david@fetter.org>
2 siblings, 0 replies; 13+ messages in thread
From: David Fetter @ 2005-08-29 23:24 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-hackers@postgresql.org
On Mon, Aug 29, 2005 at 08:15:41PM -0300, Marc G. Fournier wrote:
>
> I have a table with several 'smallint' fields that I'd like to convert to
> booleean ... the data in each is either 0 or 1, and:
>
> # select '1'::boolean;
> bool
> ------
> t
> (1 row)
> # select '0'::boolean;
> bool
> ------
> f
> (1 row)
>
> so they do cast as expected ... but, if I try to do the ALTER, I get:
>
> # ALTER TABLE table ALTER COLUMN field1 type boolean;
> ERROR: column "field1" cannot be cast to type "pg_catalog.bool"
> Should this not work? If not, is there a way to do it so that it will,
> without having to reload the whole table?
ALTER TABLE "table" ALTER COLUMN field1 TYPE boolean
USING CASE field1 WHEN 0 THEN false ELSE true END;
/* or something to this effect */
HTH :)
Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
@ 2005-08-29 23:33 ` Rod Taylor <pg@rbt.ca>
2 siblings, 0 replies; 13+ messages in thread
From: Rod Taylor @ 2005-08-29 23:33 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-hackers@postgresql.org
On Mon, 2005-08-29 at 20:15 -0300, Marc G. Fournier wrote:
> I have a table with several 'smallint' fields that I'd like to convert to
> booleean ... the data in each is either 0 or 1, and:
>
> # ALTER TABLE table ALTER COLUMN field1 type boolean;
> ERROR: column "field1" cannot be cast to type "pg_catalog.bool"
>
> Should this not work? If not, is there a way to do it so that it will,
> without having to reload the whole table?
development=# select '0'::smallint::boolean;
ERROR: cannot cast type smallint to boolean
You were casting an unknown to boolean.
Anyway, USING is what you're looking for:
ALTER TABLE table
ALTER COLUMN field1 TYPE boolean
USING CASE WHEN field1 = 0 THEN FALSE
WHEN field1 = 1 THEN TRUE
ELSE NULL
END;
--
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
@ 2005-08-29 23:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-08-30 13:17 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Greg Stark <gsstark@mit.edu>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2 siblings, 2 replies; 13+ messages in thread
From: Tom Lane @ 2005-08-29 23:49 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-hackers@postgresql.org
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> # ALTER TABLE table ALTER COLUMN field1 type boolean;
> ERROR: column "field1" cannot be cast to type "pg_catalog.bool"
> Should this not work?
No, because there's no built-in cast from smallint to bool. You could
do something like
... type boolean using case when field1=0 then false else true end;
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-08-30 13:17 ` Greg Stark <gsstark@mit.edu>
1 sibling, 0 replies; 13+ messages in thread
From: Greg Stark @ 2005-08-30 13:17 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; pgsql-hackers@postgresql.org
Tom Lane <tgl@sss.pgh.pa.us> writes:
> You could do something like
>
> ... type boolean using case when field1=0 then false else true end;
Or you could save typing and just use "USING field1<>0"
Odd that everyone did a CASE for that.
--
greg
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-09-01 20:49 ` Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 13+ messages in thread
From: Marc G. Fournier @ 2005-09-01 20:49 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-hackers@postgresql.org
On Mon, 29 Aug 2005, Tom Lane wrote:
> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> # ALTER TABLE table ALTER COLUMN field1 type boolean;
>> ERROR: column "field1" cannot be cast to type "pg_catalog.bool"
>
>> Should this not work?
>
> No, because there's no built-in cast from smallint to bool. You could
> do something like
>
> ... type boolean using case when field1=0 then false else true end;
'k, I just took a read through the "CREATE CAST" man page, and don't think
I can use that for this, but is there some way I can create a cast for
this, so that we don't have to go through the complete application and
change "VALUES ( 0 );" to "VALUES ( '0' );" ...
Again, from reading the man page, I'm guessing not, but just want to make
sure that I haven't missed anything ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
@ 2005-09-01 20:56 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 21:15 ` Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 21:23 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Andrew Dunstan <andrew@dunslane.net>
0 siblings, 2 replies; 13+ messages in thread
From: Tom Lane @ 2005-09-01 20:56 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-hackers@postgresql.org
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> On Mon, 29 Aug 2005, Tom Lane wrote:
>> No, because there's no built-in cast from smallint to bool.
> 'k, I just took a read through the "CREATE CAST" man page, and don't think
> I can use that for this,
Sure you can. Make a SQL or PLPGSQL function that does the conversion
you want and then create a cast using it.
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-09-01 21:15 ` Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 21:25 ` Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 13+ messages in thread
From: Marc G. Fournier @ 2005-09-01 21:15 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Moved off of -hackers, since its long gotten out of that realm :)
On Thu, 1 Sep 2005, Tom Lane wrote:
> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> On Mon, 29 Aug 2005, Tom Lane wrote:
>>> No, because there's no built-in cast from smallint to bool.
>
>> 'k, I just took a read through the "CREATE CAST" man page, and don't think
>> I can use that for this,
>
> Sure you can. Make a SQL or PLPGSQL function that does the conversion
> you want and then create a cast using it.
Ah, okay, I just re-read the man page and think I stumbled upon what I
overlooked the first time ...
all I want to do is:
CREATE CAST ( 0 AS boolean )
WITH FUNCTION <I have to create this>
AS ASSIGNMENT;
And then each time I try to insert a '0' into a BOOLEAN field, it will
auto convert that (based on my function) to 'f' ...
And I'd need to do a second one for 1 -> 't' ...
Am I reading it right this time ... ?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 21:15 ` Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
@ 2005-09-01 21:25 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 13+ messages in thread
From: Tom Lane @ 2005-09-01 21:25 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-sql
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> all I want to do is:
> CREATE CAST ( 0 AS boolean )
> WITH FUNCTION <I have to create this>
> AS ASSIGNMENT;
> And then each time I try to insert a '0' into a BOOLEAN field, it will
> auto convert that (based on my function) to 'f' ...
> And I'd need to do a second one for 1 -> 't' ...
No, you want one function from smallint to boolean, and the cast the
same way. (The cast is really just syntactic sugar for invoking the
function.)
Depending on what you want this to do, you might have to make the cast
IMPLICIT rather than ASSIGNMENT. I'd try ASSIGNMENT first, though,
since it's less likely to bite you when you weren't expecting it.
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-09-01 21:23 ` Andrew Dunstan <andrew@dunslane.net>
2005-09-01 21:30 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 13+ messages in thread
From: Andrew Dunstan @ 2005-09-01 21:23 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; pgsql-hackers@postgresql.org
Tom Lane wrote:
>"Marc G. Fournier" <scrappy@postgresql.org> writes:
>
>
>>On Mon, 29 Aug 2005, Tom Lane wrote:
>>
>>
>>>No, because there's no built-in cast from smallint to bool.
>>>
>>>
>
>
>
>>'k, I just took a read through the "CREATE CAST" man page, and don't think
>>I can use that for this,
>>
>>
>
>Sure you can. Make a SQL or PLPGSQL function that does the conversion
>you want and then create a cast using it.
>
>
That probably won't help him much with "values(0)":
andrew=# create function ibool(smallint) returns boolean language sql as
$$ select $1 <> 0 $$;
CREATE FUNCTION
andrew=# create cast (smallint as boolean) with function ibool(smallint)
as implicit;
CREATE CAST
andrew=# insert into foobool values(0);
ERROR: column "x" is of type boolean but expression is of type integer
HINT: You will need to rewrite or cast the expression.
Is there a way to make the builtin int to bool cast implicit?
cheers
andrew
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 21:23 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Andrew Dunstan <andrew@dunslane.net>
@ 2005-09-01 21:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 22:16 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
0 siblings, 1 reply; 13+ messages in thread
From: Tom Lane @ 2005-09-01 21:30 UTC (permalink / raw)
To: Andrew Dunstan <andrew@dunslane.net>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; pgsql-hackers@postgresql.org
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Sure you can. Make a SQL or PLPGSQL function that does the conversion
>> you want and then create a cast using it.
> That probably won't help him much with "values(0)":
If I remember the context of the original request, it wasn't about that
anyway, but about dealing with an existing smallint column.
> Is there a way to make the builtin int to bool cast implicit?
I think you'd have to go and hack the pg_cast entry ... but that cast is
new in 8.1 anyway, so it doesn't apply to Marc's problem (yet).
If we want to make it cover that specific scenario, changing it to AS
ASSIGNMENT would be sufficient; I don't think it needs to be IMPLICIT.
(I generally find cross-type-category implicit casts to be dangerous.)
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: ALTER TABLE ( smallinto -> boolean ) ...
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 20:49 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 21:23 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Andrew Dunstan <andrew@dunslane.net>
2005-09-01 21:30 ` Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-09-01 22:16 ` Marc G. Fournier <scrappy@postgresql.org>
0 siblings, 0 replies; 13+ messages in thread
From: Marc G. Fournier @ 2005-09-01 22:16 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Andrew Dunstan <andrew@dunslane.net>; Marc G. Fournier <scrappy@postgresql.org>; pgsql-hackers@postgresql.org
On Thu, 1 Sep 2005, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> Tom Lane wrote:
>>> Sure you can. Make a SQL or PLPGSQL function that does the conversion
>>> you want and then create a cast using it.
>
>> That probably won't help him much with "values(0)":
>
> If I remember the context of the original request, it wasn't about that
> anyway, but about dealing with an existing smallint column.
Nope, actually, the original was to just convert an existing table from
using smallint->boolean, but what I'm looking at with the CREATE CAST is
to avoid reducing the # of changes that I have to make to the existing
application, so being able to auto-cast 0->'f' on an INSERT/UPDATE would
help wtih that ...
The app still needs to be fixed, but this would allow for the initial
change to be made a bit easier ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ...
@ 2005-09-01 21:24 Owen Jacobson <ojacobson@osl.com>
0 siblings, 0 replies; 13+ messages in thread
From: Owen Jacobson @ 2005-09-01 21:24 UTC (permalink / raw)
To: pgsql-sql
Marc G. Fournier wrote:
> Moved off of -hackers, since its long gotten out of that realm :)
>
> On Thu, 1 Sep 2005, Tom Lane wrote:
>
> > "Marc G. Fournier" <scrappy@postgresql.org> writes:
> >> On Mon, 29 Aug 2005, Tom Lane wrote:
> >>> No, because there's no built-in cast from smallint to bool.
> >
> >> 'k, I just took a read through the "CREATE CAST" man page,
> and don't think
> >> I can use that for this,
> >
> > Sure you can. Make a SQL or PLPGSQL function that does the
> conversion
> > you want and then create a cast using it.
>
> Ah, okay, I just re-read the man page and think I stumbled
> upon what I
> overlooked the first time ...
>
> all I want to do is:
>
> CREATE CAST ( 0 AS boolean )
> WITH FUNCTION <I have to create this>
> AS ASSIGNMENT;
>
> And then each time I try to insert a '0' into a BOOLEAN
> field, it will
> auto convert that (based on my function) to 'f' ...
>
> And I'd need to do a second one for 1 -> 't' ...
>
> Am I reading it right this time ... ?
Here's what I'm using:
CREATE OR REPLACE FUNCTION int2bool (INTEGER) RETURNS BOOLEAN AS $$
SELECT ($1 != 0);
$$ LANGUAGE 'SQL' IMMUTABLE STRICT;
CREATE OR REPLACE FUNCTION bool2int (BOOLEAN) RETURNS INTEGER AS $$
SELECT CASE WHEN $1 THEN 1
WHEN NOT $1 THEN 0
ELSE NULL END;
$$ LANGUAGE 'SQL' IMMUTABLE STRICT;
CREATE CAST (INTEGER AS BOOLEAN)
WITH FUNCTION int2bool (INTEGER)
AS ASSIGNMENT;
CREATE CAST (BOOLEAN AS INTEGER)
WITH FUNCTION bool2int (BOOLEAN)
AS ASSIGNMENT;
done.
Owen
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2005-09-01 22:16 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-29 23:15 ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier <scrappy@postgresql.org>
2005-08-29 23:24 ` David Fetter <david@fetter.org>
2005-08-29 23:33 ` Rod Taylor <pg@rbt.ca>
2005-08-29 23:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-08-30 13:17 ` Greg Stark <gsstark@mit.edu>
2005-09-01 20:49 ` Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 20:56 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 21:15 ` Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 21:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 21:23 ` Andrew Dunstan <andrew@dunslane.net>
2005-09-01 21:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-01 22:16 ` Marc G. Fournier <scrappy@postgresql.org>
2005-09-01 21:24 Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Owen Jacobson <ojacobson@osl.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox