[SQL] [Fwd: Majordomo results: unsubscribe]

2004-12-15 Thread Jodi Kanter
nt is [EMAIL PROTECTED]. Both may be listed because I frequently get emails in duplicate. Any help would be greatly appreciated. Jodi Kanter Original Message Subject: Majordomo results: unsubscribe Date: Wed, 15 Dec 2004 15:55:43

[SQL] search and replace

2004-06-09 Thread Jodi Kanter
be to dump the table, use a macro to update it and then restore. Jodi -- ___ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED]      

[SQL] auto_insert

2004-01-29 Thread jodi
I'm looking function at postrgeSQL the same like "auto_insert " function at mySQL

[SQL] picking max from list

2003-12-10 Thread Jodi Kanter
            8894 Ultimately I want to know the group number for EACH rd_pk with the highest run number. Can this be done in one query? Or will I need to code with a loop? Thanks Jodi -- ___ Jodi L Kanter BioInformatics Database

[SQL] query assistance

2003-11-04 Thread Jodi Kanter
t_date   | timestamp without time zone |  sty_comments | text    |  created_by   | integer | Indexes: study_pkey primary key btree (sty_pk) I am concerened with study_name. The created_by field tells me who

Re: [SQL] looking for empty fields

2003-08-14 Thread Jodi Kanter
Title: Viorel Thank you for responding and sorry to waste your time. I just realized my stupid mistake after sending the message! It was an integer field. Jodi Viorel Dragomir wrote:   - Original Message - From: JodiKanter

[SQL] looking for empty fields

2003-08-06 Thread Jodi Kanter
arraymeasurement where al_fk is null or al_fk=''; Is this not allowed anymore? All my check with the double ticks are failing. I assume there is a difference in postgres between an empty and null field. How can I check for both in 7.3.3? Thanks Jodi -- ____

[SQL] duplicate dates

2003-08-01 Thread Jodi Kanter
tiple times. Thanks. Jodi -- ___ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED]      

[SQL] join syntax

2003-06-17 Thread Jodi Kanter
d yet I am supposed to now help him with his database and application.. Is there some documentation that would define this type of syntax? How is this handled if you have more than one table in the join? It does not appear that this format would allow for this. T