pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: pls Help us... (sql question)
2+ messages / 2 participants
[nested] [flat]

* Re: pls Help us... (sql question)
@ 2001-07-03 14:47  Ross J. Reedstrom <reedstrm@rice.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Ross J. Reedstrom @ 2001-07-03 14:47 UTC (permalink / raw)
  To: ibrahim cobanoglu <icoban77@yahoo.com>; pgsql-sql

Best to ask your questions on the list, so others may find them,
with (hopefully) helpful answers in the archives in the future.

so, you've got a table with indistinguishable rows. I'm afraid you've
got to use an non ANSI extension. Every DB I've ever used has something
equivelant. In PostgreSQL, it's the 'oid', so in your case, you'd do:

SELECT oid,Name from tablename;

and see something like:
oid       Name 
-------  -------
102453   ibrahim      first row
102455   ibrahim      second row
103756   ibrahim      third row


Then, you can delete, comparing on the oid:

DELETE FROM tablename WHERE oid=102455;

Ross

On Tue, Jul 03, 2001 at 03:23:42AM -0700, ibrahim cobanoglu wrote:
> Hi. my name is ibrahim 
> 
> i have one problem with multiple rows..
> 
> i have a table named record and this table consist one
> field (name)
> 
> in this field there are 3 values such as
> Name 
> -------
> ibrahim      first row
> ibrahim      second row
> ibrahim      third row
> 
> i want to delete only the second row. ( with  Ansi 
> SQL (no cursor, trigger, rowid, rownum,....etc.) use
> select, count, .... (whats required!) )
> 
> but i dont know How to delete..
> 
> its really improtant for me.
> 
> i will glad....
> 
> 
> 
>  
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Re: pls Help us... (sql question)
@ 2001-07-03 16:19  Richard Huxton <dev@archonet.com>
  parent: Ross J. Reedstrom <reedstrm@rice.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2001-07-03 16:19 UTC (permalink / raw)
  To: Ross J. Reedstrom <reedstrm@rice.edu>; ibrahim cobanoglu <icoban77@yahoo.com>; pgsql-sql

From: "Ross J. Reedstrom" <reedstrm@rice.edu>

> Best to ask your questions on the list, so others may find them,
> with (hopefully) helpful answers in the archives in the future.
>
> so, you've got a table with indistinguishable rows. I'm afraid you've
> got to use an non ANSI extension. Every DB I've ever used has something
> equivelant. In PostgreSQL, it's the 'oid', so in your case, you'd do:
>
> SELECT oid,Name from tablename;
>
> and see something like:
> oid       Name
> -------  -------
> 102453   ibrahim      first row
> 102455   ibrahim      second row
> 103756   ibrahim      third row
>
>
> Then, you can delete, comparing on the oid:
>
> DELETE FROM tablename WHERE oid=102455;

Ibrahim - if you want to prevent any more duplicate entries you can make the
"name" column unique - see the CREATE TABLE docs but it would be something
like:

CREATE TABLE tablename (
  "Name" varchar(64) UNIQUE;
);

Then PG will fail any attempt to insert a duplicate value (it is the same as
creating a UNIQUE index basically).

- Richard Huxton




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-07-03 16:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-03 14:47 Re: pls Help us... (sql question) Ross J. Reedstrom <reedstrm@rice.edu>
2001-07-03 16:19 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox