Re: SQL pour trouver le premier libre?

From: Jean-Paul Argudo <jean-paul(at)argudo(dot)org>
To: Jean-Paul Argudo <jean-paul(at)argudo(dot)org>
Cc: Pierre Couderc <pierre(at)couderc(dot)cc>, pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: SQL pour trouver le premier libre?
Date: 2006-06-03 09:38:00
Message-ID: 44815878.1060407@argudo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

Arf!

Désolé, c'est samedi matin:

test2=> select a+1 as id_disponible from nombres where a-1>0 except
select a from nombres order by id_disponible limit 1;

id_disponible
---------------
4
(1 ligne)

Mieux, non :-)

Cordialement,

--
Jean-Paul Argudo

In response to

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Jean-Paul Argudo 2006-06-03 09:43:09 Re: SQL pour trouver le premier libre?
Previous Message Jean-Paul Argudo 2006-06-03 09:36:11 Re: SQL pour trouver le premier libre?