Hello,
I have noticed that the link toward pgsql-sql is missing on the left
menu at http://archives.postgresql.org/.
Is that normal?
--
***
Richard NAGY
Nameshield
46, rue Jean BODIN
F-49000 Angers
Tél : +33 2 41 18 28 28
Tom Lane a écrit :
Richard NAGY <[EMAIL PROTECTED]> writes:
> SELECT aes.ent_id, e.type, e.nom, aes.sect_id as voulu,
> cvd_new(current_date, e.date_entree, 'new') FROM ass_entrep_sectact
aes,
> entreprise e WHERE e.id = aes.ent_id and aes.sect_id <> 3 and
>
ing tested. Yes, it works well.
--
Richard NAGY
Presenceweb
EMAIL PROTECTED]
and data management solutions
(415) 565-7293
for law firms, small businesses
fax 621-2533
and non-profit organizations.
San Francisco
Hello Josh,
Yes, it works! I don't know exactly why, but it works!
Thanks a lot.
--
Richard NAGY
Presenceweb
ow, the
query works well without any error. It is ordered but I think it is certainly
due to the fact that the table was already ordered on disk. So, I have
no more errors but I'm not sure that it is completely good.
PS : The interface tool that I have used to send queries to the database
was psql.
Regards
--
Richard NAGY
Presenceweb
t WHERE sect_id = 56 and
sect_id <> 3
and sect_id <> 9 and sect_id <> 1 and sect_id <> 13) ORDER
BY e.type, e.nom
Now, if I want that my request works well, I have to remove the order
by statement. But, of course, it is not ordered any more.
So how can I translate this request to one which can work with
an order by statement ?
Thanks.
--
Richard NAGY
Presenceweb
