Re: [SQL] catch an 'update where false' ?

Hi thanks all for your answers ! to Lane Van Ingen: my purpose is to write a trigger on update so that 'users' might then us update without having to perform the if found. I don't know if I was clear about that idea, but the checks on where update will or not succeed, is what I'm trying to hide f

[SQL] How to encrypt a column

Hi,   I'm interested in encrypting column in table.  Are there any example using "C" to create the encrypted column, inserting and retreiving data  to/from it?   Thank you  __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection aroun

[SQL] sql function: using set as argument

Hi,   I have a function that returns a set. Looks like:     Select a_column from a_table where some_condition;   I want to use output of this function as an argument of another function     Second looks like:     Get_count(result_set_of_function_

[SQL] insert into / select from / serial problem

I am using a insert statement like: INSERT INTO newtable SELECT field1, field2 FROM anothertable newtable structure is: serial, varchar, varchar What syntax do I use to insert the serial field? Ive tried something like: INSERT INTO newtable SELECT nextval('newtable_id_seq'), field1, field2 FRO

[SQL] Select problems

Hi: I've just migrated from Linux/PostgreSQL 7.2 to Windows/PostgreSQL 8.0.3. I have a large view. When I make: "Select . WHERE mydate = 'anydate'" the view lasts 19 seconds to complete. But, when I make: "Select . WHERE mydate >= 'anydate'" the view lasts 7 minutes. With PostgreSQL 7

[SQL] Parentheses in FROM clause and evaluation order.

Hi, I thought that the parenthesis in the table expression (FROM clause), could be used to indicate the desired evaluation order. But, I tried with a couple of samples and the explain command returned me the same result; no matter what parentheses association I used. I am using only INNER JOINs.

[SQL] trigger between to different database

Hi everybody, I have two databasese: database1 and database2. I want to set a trigger on a table of database1 which will insert some values to a table of database2. Is it possible with postgresql? How can I find detailed information about that? Thanks in advance, haris ---

Re: [SQL] sum but not grouped by?

let ff your table... try this: select     a.id,     a.date,     a.hours,     (select sum(b.hours)         from ff as b         where a.id = b.id         group by b.id     ) as a     from ff as a; bye, Luca Henry Ortega ha scritto: I have the ff data: id | date |

Re: [SQL] insert into / select from / serial problem

"tgh002" <[EMAIL PROTECTED]> writes: > I am using a insert statement like: > INSERT INTO newtable > SELECT field1, field2 FROM anothertable > newtable structure is: serial, varchar, varchar > What syntax do I use to insert the serial field? I think you want to just let it default, which you'd do

Re: [SQL] trigger between to different database

On Tuesday 09 Aug 2005 12:11 am, Haris Saybasili wrote: > Hi everybody, > > I have two databasese: database1 and database2. I want to set a > trigger on a table of database1 which will insert some values to a > table of database2. > > Is it possible with postgresql? How can I find detailed informat

Re: [SQL] trigger between to different database

On Mon, Aug 08, 2005 at 09:41:22PM +0300, Haris Saybasili wrote: > > I have two databasese: database1 and database2. I want to set a > trigger on a table of database1 which will insert some values to a > table of database2. You could use contrib/dblink but you wouldn't have transaction semantics.

Re: [SQL] catch an 'update where false' ?

On Sun, Aug 14, 2005 at 03:13:15PM +0200, santiago wrote: > according to my book, triggers are only implemented whit the FOR EACH > ROW clause in postgres, and not available in the FOR EACH STATEMENT > case. has this changed in some new version ? which shall I use then ? Yes, it was added in rele