RE: [SQL] Duplicate tuples with unique index - Mailing list pgsql-sql

From Iain.Mott@CMIS.CSIRO.AU
Subject RE: [SQL] Duplicate tuples with unique index
Date
Msg-id A9560E746CADD111B8AA00A0C9A398C3411303@bmw.act.cmis.CSIRO.AU
Whole thread Raw
List pgsql-sql
Dear List

I'm new to SQL and databases in general. I'm writing an interface to
postgresql in C for a music application.

Presently, my interface returns instances of each query with an index. This
is done in my coding rather than a result of the SQL query itself. 

Is there a simple way to ask for an index to each instance of a query in
SQL? (positioned in the first field of the results).

Cheers,


Iain Mott
<http://soundart.tripod.com>


pgsql-sql by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [HACKERS] Re: [SQL] DISTINCT ON: speak now or forever hold your peace
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: [SQL] DISTINCT ON: speak now or forever hold your peace