[SQL] Determining logically unique entities across many partially complete rows where at least one column matches

2009-08-10 Thread Jamie Tufnell
Hi, I am faced with a modeling problem and thought I'd see if anyone has run into something similar and can offer some advice. Basically my problem domain is cataloguing "snippets of information" about "entities" which are loosely identified. Entities can be identified up to 3 different methods

Re: [SQL] Import (.CVS File) to postgreSql

2009-08-10 Thread A. Kretschmer
In response to Premila Devi : > Dear All, > > > > I like to import (.CVS File) to postgreSql.Could anyone help me. May I know, > what the requirement. You can use the COPY-command for that, see the doc. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr:

Re: [SQL] Import (.CVS File) to postgreSql

2009-08-10 Thread Shoaib Mir
On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi < premiladevi.daya...@agbnielsen.com> wrote: > Dear Sir, > > > > I am really don’t understand Sir. May I have a screenshot on how to make > these configuration sir. > > > > The File is in CVS, as I attached before sir. > > > As I told you before just

Re: [SQL] Import (.CVS File) to postgreSql

2009-08-10 Thread Shoaib Mir
On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi < premiladevi.daya...@agbnielsen.com> wrote: > Dear All, > > > > I like to import (.CVS File) to postgreSql.Could anyone help me. May I > know, what the requirement. > > > COPY command should be your friend in that case --> http://www.postgresql.org/

[SQL] Import (.CVS File) to postgreSql

2009-08-10 Thread Premila Devi
Dear All, I like to import (.CVS File) to postgreSql.Could anyone help me. May I know, what the requirement. Herewith I attach an Example of CVS File,Plese tell me how to restore in Postgresql. Thank you. http://cs.agbnmr.com/ci/autocomposition/logo_agb

[SQL] Updating a specific number of rows in pl/pgsql

2009-08-10 Thread Peter Headland
I'm working on a queuing application. As part of this I'm trying to write a pl/pgsql function that updates a specific number of rows in the most efficient way possible. Multiple queues are contained within a single table. I can get the rows I want to update like this: SELECT * FROM queue