Tom Lane wrote:
Wang Mike [EMAIL PROTECTED] writes:
but this query: select * from test_uuid where id =
'df2b10aa-a31d-11d7-9867-0050babb6029'::uuid dosn't use index
QUERY PLAN
---
Seq Scan on
.
So, it seems to make it clear in docs would be a good help to function
writers,
would commit a documentation patch later if necessary.
Thank you!
Regards
Laser
Tom Lane wrote:
Weiping He [EMAIL PROTECTED] writes:
the situation trun worse: now the explain shows the query using the
index
Tom Lane wrote:
Weiping He [EMAIL PROTECTED] writes:
we found the problem:
We used IMMUTABLE modifier in our CREATE FUNCTION definition,
though it's correct for our function to return same value if input the
same *data*,
but our data are passed by reference, not by value, so, some times we
Tom Lane wrote:
Weiping He [EMAIL PROTECTED] writes:
because the data type (UUID) is a struct,
and the uuid_eq() function accept two pointer to the value of struct uuid,
if make it IMMUTABLE, postgresql would think it should not try to run
the function, but return the cached value instead when
Hi,
I'm trying to compile pgsql-7.4devl on Solaris8, but got the error
below:
8-
numeric.c: In function `PGTYPESnumeric_cmp':
numeric.c:1308: `INT_MAX' undeclared (first use in this
Tom Lane wrote:
I think Bruce already fixed this. How old is your CVS pull?
regards, tom lane
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
upgraded this morning, around 2003-07-04 09:29:00 CST or
When trying to build the CVS source on a HP-UX 11.00 box:
HP-UX hpux B.11.00 A 9000/800
We got the configure error:
error
checking types of arguments for accept()... configure: error: could not
determine argument types
/error
Check the config.log, it said that the configure script can't find the
Tom Lane wrote:
Weiping He [EMAIL PROTECTED] writes:
Check the config.log, it said that the configure script can't find the
argument types
fo 'accept()'.
Could you show us the relevant section of config.log, instead of giving
a summary with no details? I'd like to see the compiler
Tom Lane wrote:
Weiping He [EMAIL PROTECTED] writes:
I've put the config.log on:
http://www.pgsqldb.org/config.log
configure:10847: cc -Ae -c +O2 -D_XOPEN_SOURCE_EXTENDED conftest.c 5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product;
ignored.
Get