Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL

2003-12-02 Thread Jan Wieck
scott.marlowe wrote: On Mon, 1 Dec 2003, Jan Wieck wrote: Jason Tesser wrote: > Quoted as gospel by various people: >>> MySQL cannot even handle sub-queries yet. > >> BTW, is that really still true? I thought they had at least some >> support for subqueries by now. > > yes sub queries in 4.1

Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL

2003-12-02 Thread scott.marlowe
On Tue, 2 Dec 2003, Jan Wieck wrote: > scott.marlowe wrote: > > > On Mon, 1 Dec 2003, Jan Wieck wrote: > > > >> Jason Tesser wrote: > >> > >> > Quoted as gospel by various people: > >> >>> MySQL cannot even handle sub-queries yet. > >> > > >> >> BTW, is that really still true? I thought they

Re: [GENERAL] Feature Request for 7.5

2003-12-02 Thread Scott Ribe
>> I have been looking into how to ensure that synchronous replication, etc. >> could best be implimented. To date, I see only two options: incorporate >> the replication code into the database backend or have a separate "proxy" >> which handles the replication. > > There are many problems with

Re: [GENERAL] perl(Pg) (S)RPM

2003-12-02 Thread Roderick A. Anderson
On Tue, 2 Dec 2003, Lamar Owen wrote: > Because Pg is no longer distributed as a part of the main tarball, but a > contrib is being distributed that requires it. This is an issue with the > main tarball, not with the RPM packaging, IMO. Someone needs to step up to > the plate and build a Pg R

Re: [GENERAL] Error in select

2003-12-02 Thread Tom Lane
Carmen Gloria Sepulveda Dedes <[EMAIL PROTECTED]> writes: > I get: > ERROR: variable not found in subplan target list Could we have enough context to reproduce the problem? I don't have time to guess at your table definitions ... regards, tom lane --

Re: [GENERAL] bytea -> text

2003-12-02 Thread Tom Lane
Baldur Norddahl <[EMAIL PROTECTED]> writes: > Seems like "like" knows how to convert bytea to text, No, it doesn't. The reason that works is there's a LIKE operator for bytea (try "\do ~~" in psql). regards, tom lane ---(end of broadcast)-

Re: [GENERAL] embedded postgresql + C++ IDE

2003-12-02 Thread jini us
Thanks for all the answers. It seems if I wish to make my idea into reality I will have to invest in the Profesional Microsoft Visual C++ studio. Having said that if anyone can help me with a cheap copy of the developer studio which you do not want and want to sell it to me very very cheap. I w

Re: [GENERAL] embedded postgresql + C++ IDE

2003-12-02 Thread jini us
Thanks for all the answers. It seems if I wish to make my idea into reality I will have to invest in the Profesional Microsoft Visual C++ studio. Having said that if anyone can help me with a cheap copy of the developer studio which you do not want and want to sell it to me very very cheap. I w

Re: [GENERAL] perl(Pg) (S)RPM

2003-12-02 Thread Lamar Owen
On Tuesday 02 December 2003 06:05 pm, Roderick A. Anderson wrote: > On Tue, 2 Dec 2003, Lamar Owen wrote: > > exists). If no one else can do this, I can, but it's not high on my list > > of priorities. > What you have a life? :-) And four kidsoh, that's an 'l', not a 'w' :-) > OK it i

[GENERAL] DBD::Pg problem

2003-12-02 Thread Ausrack Webmaster
Hi I am trying to insert a simple email address into a text field, and I get the below error: DBD::Pg::st execute failed: ERROR: pg_atoi: error in "<[EMAIL PROTECTED]>": can't parse "<[EMAIL PROTECTED]>" I figure it is because of the < and @ in the value, but why does it take these as operat

Re: [GENERAL] DBD::Pg problem

2003-12-02 Thread Martijn van Oosterhout
pg_atoi is the string to int converter. You're trying to insert it into an integer field. On Wed, Dec 03, 2003 at 03:45:53PM +0900, Ausrack Webmaster wrote: > Hi > > I am trying to insert a simple email address into a text field, > and I get the below error: > > DBD::Pg::st execute failed: ER