Hubert Palme <[EMAIL PROTECTED]> writes:
> adressen=> CREATE INDEX xxx ON geburtstage (geb_monat(geburtstag));
> ERROR: DefineIndex: (null) class not found
> adressen=>
Apparently you're using 6.5 or older ... I'd recommend updating!
IIRC, in <= 6.5 you *must* specify an operator class for a fu
Stephan Szabo wrote:
>
> Functional indexes cannot currently take constant values to the function,
> so it's complaining about the constant 'month'. The current workaround is
> probably to create a function that does the date_part('month', ) for
> you and then use that function in the index crea
Stephan Szabo wrote:
>
> Functional indexes cannot currently take constant values to the function,
> so it's complaining about the constant 'month'. The current workaround is
> probably to create a function that does the date_part('month', ) for
> you and then use that function in the index crea
Stephan Szabo wrote:
>
> Functional indexes cannot currently take constant values to the function,
> so it's complaining about the constant 'month'. The current workaround is
> probably to create a function that does the date_part('month', ) for
> you and then use that function in the index crea
You can use two quote characters to get a single quote in the quoted
string, so ''month''
On Thu, 8 Feb 2001, Hubert Palme wrote:
> Stephan Szabo wrote:
> >
> > Functional indexes cannot currently take constant values to the function,
> > so it's complaining about the constant 'month'. The cu
Functional indexes cannot currently take constant values to the function,
so it's complaining about the constant 'month'. The current workaround is
probably to create a function that does the date_part('month', ) for
you and then use that function in the index creation.
On Sat, 3 Feb 2001, Hube
Hi,
could someone, please, explain me the following parse error?
adressen=> \d geburtstage
Table= geburtstage
+--+--+---+
| Field | Type|
Length|
+-
