array[10]

From: Marco Kaerger <m(dot)kaerger(at)vitrado(dot)de>
To: PostgreSQL Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: array[10]
Date: 2003-08-12 17:30:04
Message-ID: 1060709405.1478.19.camel@vitrado-002
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi there,

i have got a problem concerning arrays in postgres
i created a function in which i want to know if the index 8 of var_array
ist not NULL:

IF var_array[8] IS NOT NULL

THEN

(query)

END IF;

then i call the function and the query is submitted, allthough
var_array[8] is 'NULL'

any solutions for that problem?

thanx!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Kambhampaty 2003-08-12 17:37:37 Re: Backup routine
Previous Message Robert Treat 2003-08-12 14:46:37 Re: pg_autovacuum ?