Re: [SQL] foreign key problem

;ve tried to reproduce this, but haven't been able > > to yet. This has happened to use several times. > > Oh, forgot question 2: > SELECT version()? > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com --

[SQL] foreign key problem

somehow we've ended up with rows in table2 that have table1_ids that do not exist in table1. How is this possible? I've tried to reproduce this, but haven't been able to yet. This has happened to use several times. Thanks for any help, -- Laurette Cisneros The Database Group

[SQL] format timestamp

milliseconds). Or even more specific, I want the COPY to be local to the client so I use stdout and redirect it to a file. In order to keep the acuracy on the timestamp fields, I need to COPY BINARY. This can not be used in conjunction with stdout. Any suggestions? -- Laurette Cisneros (510) 420-3137

[SQL] quick server c question

Hi all, My c is rusty and you are all pros!...so... I want to write a server routine that will return a string so that when "SELECT retstr() from tbl;" is executed this string is returned. What's the best way to do this? i.e. create: CREATE FUNCTION retstr() RETURNS char??? AS '/tmp/tst.