Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Unanswered: Built-in function LNNVL

    Hi , i am trying to get the postgreSQL equivalent of Oracle's LNNVL function .

    Details about Oracle's LNNVL function are available in below link

    http://www.stanford.edu/dept/itss/do...htm#sthref1392

    Can u suggest me the equivalent for this in PostgreSQL .

    Is LNNVL supported in PostgreSQL

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by Oracle
    LNNVL ... takes as an argument a condition and returns TRUE if the condition is FALSE or UNKNOWN and FALSE if the condition is TRUE.
    Try something along these lines:

    Code:
    Select Foo from Bar where  Coalesce (Not (Expression),  True)
    You could, of course, write your own LNNVL function using a similar approach.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •