Hi Le 19/06/2011 04:27, lover boi a écrit : > SELECT > MY_FUNCTION(...) AS my_function, > CASE WHEN my_function = '...' THEN '...' ELSE '...' END > ... > ...
WITH T AS (SELECT MY_FUNCTION(...) AS my_function, ... ) SELECT CASE WHEN my_function = '...' THEN '...' ELSE '...' END ... ... A + -- Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66 Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence Audit, conseil, expertise, formation, modélisation, tuning, optimisation *********************** http://www.sqlspot.com ************************* -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
