Based on the below each row could end up returning a different data type
compared to a previous row for that column.
SELECT COALESCE( CAST(f.number as varchar(100)) , f.name) FROM
Whatever f.name is set to in terms of the max length of varchar, if any,
is what f.number should be cast to.
mik
Hello All,
Attempting to select two different column types with COALESCE returns
this error:
ERROR: COALESCE types smallint and character varying cannot be matched
Attempting the same thing with a CASE statement returns a similar error:
ERROR: CASE types smallint and character varying cannot
On Sat, Dec 30, 2006 at 10:33:01AM -0800, novnov wrote:
>
> The pagila database has generic trigger function called last_updated() (shown
> below) which is used to update timestamp columns in various tables. The
> reason I can't use the function 'as is' for my own purposes is that in my
> app the
On Thu, Dec 28, 2006 at 09:11:24AM -0700, Scott Ribe wrote:
> > and
> > added the appropriate items to /etc/sysctl.conf
>
> 1) The location may be out of date. Don't add to /etc/sysctl.conf; edit the
> values already in /etc/rc. Where you set these values has shifted around
> somewhat in OS X rele
The pagila database has generic trigger function called last_updated() (shown
below) which is used to update timestamp columns in various tables. The
reason I can't use the function 'as is' for my own purposes is that in my
app the timestamp fields are not all named alike. The field names do follo
[
you should reply to the list, not only to single posters.
this way, more people see your reply,and can help you.
Putting the list back, and quoting whole message.
]
On lau, 2006-12-30 at 15:17 +0530, karthik nandagiri wrote:
> hello ragnar,
>
> i am using postgresql version8.0. it is in
On 30 Dec 2006 at 11:32, wrote:
> nothing show on the page. So I write it works. I write
Did PostgreSQL support show up in the phpinfo() output? - there
should be a section entitled "pgsql". I've only used PHP on Windows,
but this might help point you in the right direction.
--Ray.
-
