Re: [SQL] How to implement Microsoft Access boolean (YESNO)

Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > "Jesper K. Pedersen" <[EMAIL PROTECTED]> writes: > >> Having checked the I/O format it seems that MS Access exports the > >> values of a YESNO field as 0 and 1 > > > If only Postgres's boolean type were as helpful.

Re: [SQL] How to implement Microsoft Access boolean (YESNO)

Greg Stark <[EMAIL PROTECTED]> writes: > "Jesper K. Pedersen" <[EMAIL PROTECTED]> writes: >> Having checked the I/O format it seems that MS Access exports the >> values of a YESNO field as 0 and 1 > If only Postgres's boolean type were as helpful. There's a cast to int in 8.1, and you can roll-yo

Re: [SQL] How to implement Microsoft Access boolean (YESNO)

"Jesper K. Pedersen" <[EMAIL PROTECTED]> writes: > Having checked the I/O format it seems that MS Access exports the > values of a YESNO field as 0 and 1 If only Postgres's boolean type were as helpful. -- greg ---(end of broadcast)--- TIP 3: H

Re: [SQL] pgadmin

Mark Fenbers <[EMAIL PROTECTED]> writes: > ... I don't have a stripped down > version of the O/S either... it's pretty much a full install of RH9. > I'm thinking that I must be doing something wrong. Er ... using RH9 maybe? That's been obsolete for a long time. Fedora Core 3 or 4 would be somet

Re: [SQL] pgadmin

Mark Fenbers wrote: > I'm having trouble with installing pgadmin. If this is not the > apporpriate group for seeking help with this, please excuse > me and tell > the correct one. I have not found anything else more appropriate. > > 'make' for pgadmin fails, I think it is because I don't hav

[SQL] pgadmin

I'm having trouble with installing pgadmin. If this is not the apporpriate group for seeking help with this, please excuse me and tell the correct one. I have not found anything else more appropriate. 'make' for pgadmin fails, I think it is because I don't have wxWidgets. wxWidgets fails.

Re: [SQL] select and as doubt

On Sun, Jan 15, 2006 at 12:59:48 -0200, Alexandre Gonçalves Jacarandá <[EMAIL PROTECTED]> wrote: > Thanks for reply Tom, but which docs should I read for that ? The documentation for whatever ever programming language you will be using to generate the queries. > > Tom Lane escreveu: > > =?ISO-

[SQL] DBMirror.pl performance change

Steven Hi, i hope you are ok. I discovered a problem in DBMirror.pl, performance wise. pending.c stores data in a way very similar to the PgSQL input "\" escaped format. When the field is of type bytea, and the source of data is binary, then this produces 2 additional backslashes for every unpr