Kynn Jones wrote:
Is there a less laborious approach? The root of needing to go through all this song and dance is that I don't know of any way to set up a simple temporary variable to hold a value. The temporary table is the closest I can come up to implementing a temporary variable. Is there a simpler approach?
See the message thread "can I define own variable?" for a discussion of how to create a temporarily variable. Took place over the last week.
-- Guy Rouillier ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/