--- Tom Lane <[EMAIL PROTECTED]> wrote:
> m w <[EMAIL PROTECTED]> writes:
> > If I write a function that does a 'tolower()' on
> each
> > character of a parameter passed into my function,
> do I
> > have to allocate a new text object and initialize
If I write a function that does a 'tolower()' on each
character of a parameter passed into my function, do I
have to allocate a new text object and initialize it
and copy the data, or can I modify that object in
place and return it?
Modifying it in place will save the overhead of an
alloc call, a
> Subject: like vs '='
>
> I have a function to transform text into a
> pseudo-metaphone variable, take this
> example:
>
> cddbsql=# select song, metatext(song) from cdsongs
> where metatext(song) like
> metatext('born to run') limit 3 ;
> song | metatext
> -+--
> B
Is there a formal way of submiting something to the
contrib section of the distribution?
__
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--- Hannu Krosing <[EMAIL PROTECTED]> wrote:
> Should we not examine "the _possible_ outputs of
> every C-coded function
> to make sure it produces a valid value of the
> datatype" ;)
>
> For me producing an invalid data for a datatype
> seems very much like
> a bug and it _should_ be reporte
Embedded zeroes aren't supported in
> char/varchar/text fields,
> and cannot be supported in a portable fashion, since
> these datatypes
> rely on functions like strcoll() that don't allow
> embedded nulls in
> strings. It wouldn't surprise me too much if there
> are inconsistent
> behaviors bet
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> m w <[EMAIL PROTECTED]> writes:
> > Here is the problem: Depending on whether there is
> an
> > index or not, 'like' behaves differently.
>
> Please provide a complete, self-contained example
> with whic
--- Zeugswetter Andreas SB
<[EMAIL PROTECTED]> wrote:
>
> > > > I am reposting this because I'm not sure it
> actually
> > > > made it to the list.
> > >
> > > It did make it to the list, but can you give
> more
> > > details whether or which of the
> > > following you use:
> > > --enable-loc
I am reposting this because I'm not sure it actually
made it to the list.
I have a function to transform text into a
pseudo-metaphone variable, take this example:
cddbsql=# select song, metatext(song) from cdsongs
where metatext(song) like metatext('born to run')
limit 3 ;
song | metate
In 7.1 the row limit is not as big a deal because of
tuple toaster. I had a 7.0 database that needed the
row limit change, in 7.1 it does not seem too.
But if you want to chang it anyway, in config.h, look
for this line:
#define BLCKSZ 8192
It can be made as large as 32768.
--- Manuel Cabido
I have a function to transform text into a
pseudo-metaphone variable, take this
example:
cddbsql=# select song, metatext(song) from cdsongs
where metatext(song) like
metatext('born to run') limit 3 ;
song | metatext
-+--
Born To Run | brntorn
Born To Run | brntorn
B
11 matches
Mail list logo