Re: Return Record with CASE problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
Cc: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Return Record with CASE problem
Date: 2003-06-11 14:35:26
Message-ID: 20030611073435.L90810-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 11 Jun 2003, Rory Campbell-Lange wrote:

> Thanks for the response, Stephan.
>
> I ommitted to say that selecting AS typer varchar doesn't work either.

Looks like it's getting typed as text actually, so try that (or explicitly
type the constants to varchar or text or whatever).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Witney 2003-06-11 14:44:17 Re: How to find the definition of a sequence ?
Previous Message Network Administrator 2003-06-11 14:17:47 Re: [GENERAL] MySQL gets $19.5 MM