Re: [SQL] TR: Like and =

In fact I'm trying to migrate a database from Informix IDS to Postgres. This IDS database uses CHAR so I just let the same. Now I'm conviced that I sould convert CHAR to VARCHAR. Thanks. > -Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de Dani Oderbolz >

Re: [SQL] Rules: passing new/old to functions

Gunter Diehl <[EMAIL PROTECTED]> writes: > create funtion f1(v, v) returns void as '...' > create rule vupt as on update to v do instead select f1(new, old) > While accepting this definitions, pg says it can not handle "whole-tuple > references" at runtime. FWIW, the "old" case works fine. "new"

Re: [SQL] UPDATE table SET col = (SELECT ...)

On Wednesday 25 June 2003 11:00, Vangelis-Maria Tougia wrote: > Hi, > I found follwing email sent to you in internet. > I am interested in same issue myself. > Did you finally found out any more information about how to Update a column > of a table by selecting value from another table? Not sure i

[SQL] Postgres - Delphi Application

Hi   I' would like to connect my postgres database on a linux server with Delphi 5 Applications,which are located on Win95/98 Clients, very helpful would be an example on how to realize a connection of these things   Thanks   Murali

[SQL] UPDATE table SET col = (SELECT ...)

Hi, I found follwing email sent to you in internet. I am interested in same issue myself. Did you finally found out any more information about how to Update a column of a table by selecting value from another table?     Hello,If I understand the SQL references I have read, UPDATEs are allow

Re: [SQL] Informing end-user of check constraint rules

> Am Sonntag, 22. Juni 2003 14:45 schrieb [EMAIL PROTECTED]: >> I have not used column check constraints before, but I'd like to >> start using then and so would I'll like to know if there is a direct >> way to provide feedback to the end user about data validation rules >> expressed in column che

[SQL] Rules: passing new/old to functions

How to pass the special variables new / old to functions? e.g. I'd like to to something like this (v is a view): create funtion f1(v, v) returns void as '...' create rule vupt as on update to v do instead select f1(new, old) While accepting this definitions, pg says it can not handle "whole-tupl

Re: [SQL] Temporary table performance?

> I could then do some queries against the temporary table without having to > regenerate the results every time I want to show a "Page 299 of 500" toolbar. Performance wise temp tables are the same as a regular table but without WAL on the table contents. > Would I be better off just sucking th

[SQL] Temporary table performance?

Hello everyone, In the Intranet application I've been building over the past 9 months, I have developed quite a beast of a search. I've asked for help here in the past on performance tuning it, and have come to the conclusion that I've gotten it as tweaked as I can without seeking the counsel

Re: [SQL] Change the behaviour of the SERIAL "Type"

Wow, I had never actually faced this problem (yet) but I spied it as a possible stumbling block for porting MySQL apps, for which the standard practice is inserting a NULL. As I have made a fairly thorough reading of the docs (but may have not cross-correlated every piece of data yet, obviousl

[SQL] contrib/tsearch - chopped words?

Hello list, I have followed the examples in README.tsearch about converting text columns to txtidx type using the function txt2txidx() . Problem is.. some words become chopped. "Database for dummies" becomes 'dummi' 'databas' , for example. I also created a trigger to update the txtidx colum

Re: [SQL] Join or Where?

On Thursday 26 Jun 2003 12:21 pm, Együd Csaba wrote: > Urgent Help : Use of return from function/procedure.Hi, > could anybody tell me what can be the difference between these queries? > There are a big difference but I can't understand the reasons. For some > reasons the firs query calculates getu

Re: [SQL] Change the behaviour of the SERIAL "Type"

On Thu, Jun 26, 2003 at 14:31:34 +0200, Dani Oderbolz <[EMAIL PROTECTED]> wrote: > > It was written for MySQL, which can take NULL and then assign an > auto_increment. > However, in PostgreSQL I am getting problems, because it would not let > me insert NULL > into a NOT NULL column (which is p

[SQL] Change the behaviour of the SERIAL "Type"

Hi all, I am struggling hard with a badly written piece of code. It has such statements all over the place: INSERT INTO TABLE A (NULL, Value1, Value2...). It was written for MySQL, which can take NULL and then assign an auto_increment. However, in PostgreSQL I am getting problems, because it woul

[SQL] Join or Where?

Title: Urgent Help : Use of return from function/procedure. Hi,could anybody tell me what can be the difference between these queries?There are a big difference but I can't understand the reasons. For somereasons the firs query calculates getup column in a wrong way. It allwaysdevides with 10

[SQL] Object based Query Requirement.

Title: Object based Query Requirement. Hi, I use Postgres-7.2.4. and my client is in C++ I need to know the following: As I user libpq++ library, I have to pass the query in the string format only. i.e.’const  char *’ Does Postgres support object based query? i.e. User should make the obj