At 04:00 p.m. 30/05/2013, Cam wrote: >Using version 2.5.2 >Is the case statement available in PSQL - specifically stored procedure.
Depends what you're asking for here. The DML CASE operator can be used in a stored procedure, as elsewhere. PSQL has no switching CASE statement construct such as you have in C++, Java, Delphi, etc. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of "The Firebird Book" and "The Firebird Book Second Edition" http://www.firebird-books.net __________________________________________________________________
