On Wed, Aug 10, 2005 at 04:43:50PM +0100, Nigel Horne wrote: > Has anyone got any pointers to how to define an null indicator > variable to get over the above cryptic message? Without more information we can only guess. The only place in the PostgreSQL source code that contains the string "NULL value without indicator" is in the ECPG code, so I'll guess that you're using ECPG and doing something like this: EXEC SQL SELECT somecolumn INTO :foo FROM sometable WHERE id = 1234; If that's the case, then see "Indicators" in the ECPG documentation. Here's a link to the latest version: http://www.postgresql.org/docs/8.0/static/ecpg-variables.html#AEN25258 If that's not what you're doing, then please provide more information. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org