PostgreSQL

Поиск
Список
Период
Сортировка
От Horaci Cuevas
Тема PostgreSQL
Дата
Msg-id NABBJFCKFCOHFBNGLGHOAEGDCDAA.hcuevas@perti.com
обсуждение исходный текст
Список pgsql-general
Hi!

    I'm using PostgreSQL for a search-web based database, and i saw a missing
    function mostly found in DB2 and others, where, you can get results from
    a query having a WHERE condition to exist or not in another SQL sentence .

    In DB2 is:

        SELECT field1, field2 FROM tab1 WHERE field1 IN ( select field3 from tab2 )
    or
        SELECT field1, field2 FROM tab1 where field1 NOT IN ( select field3 from tab2 )

    PostgreSQL already has that, but only allows to return 1 result, ex:

        SELECT field1, field2 FROM tab1 where field1 =
            ( select field 3 from tab2 where id=1 )

    Would be great if that where added to the TODO as a future Feature.

Thanks in Advance.
Horaci Cuevas.


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Следующее
От: "Mike Mascari"
Дата:
Сообщение: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions