Re: [SQL] Alternative to INTERSECT

2007-07-31 Thread Josh Trutwin
On Tue, 31 Jul 2007 17:30:51 + Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > Hi all. I have the following schema: > > CREATE TABLE test ( > id integer NOT NULL, > field character varying NOT NULL, > value character varying NOT NULL > ); > > ALTER TABLE ONLY test > ADD CON

Re: [SQL] Accessing field of OLD in trigger

2007-10-12 Thread Josh Trutwin
On Fri, 12 Oct 2007 12:00:55 +0200 (CEST) Daniel Drotos <[EMAIL PROTECTED]> wrote: > Hi, > > > I'm working on a row level plpgsql trigger running after delete, > using a 8.0.3 server. It gets a parameter which is a field name of > the OLD record. How can that field be accessed? > > I'd like to

Re: [SQL] Table to Excel

2009-03-26 Thread Josh Trutwin
On Thu, 26 Mar 2009 08:04:25 +0100 Pavel Stehule wrote: > hello > > use csv format - excel have to read this format without any format > > COPY tablename TO '...' CSV; Another possibility that I use often is to set the output to HTML mode using: \H Then set to send query results to a file: