Re: question about count(b) where b is a custom type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: question about count(b) where b is a custom type
Date: 2005-11-16 15:22:53
Message-ID: 5917.1132154573@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> writes:
> I have few fprintf(stderr,""") in function that converts internal
> rep. into string. I was really supprised to see them on me screen when :
> select count(b) from blah where b ~ 'something';
> was issued. What the hell, isn't it wrong ?

Depends ... what does the ~ operator do for your datatype? (If you've
defined an implicit conversion to text then it's very possibly invoking
that followed by the regex match operator.)

Have you tried getting a stack trace back from your function to see
exactly what is calling it?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-16 15:36:49 Re: OS X 7.4 failure
Previous Message Tom Lane 2005-11-16 15:07:24 Re: PG_DUMP and table locking in PG7.4