Can you give us the actual delete command you are issuing?
You need to specify the types of the function arguments when deleting
functions, for example:
DELETE FUNCTION my_sum (int, int);
etc.
Cheers,
Bob Edwards.
Penchalaiah P. wrote:
Hi good morning to all….
I created some functions in
Markus Schaber wrote:
Hi, Robert,
Robert Edwards wrote:
(this is my first post to this list...)
Welcome here. :-)
I am wondering if Postgres, and/or SQL in general, has a facility to
run a function at connection set-up time (after a successful connection
attempt) and/or at session comple
gabor <[EMAIL PROTECTED]> writes:
> i have a table, where there is a varchar(500) column,
> which contains data that is strangely formatted:
> it starts with letters, and ends with a number.
> for example:
> xyz001
> xyz002
> xyz044
> xyz1243
> abc01
> abc993
> abc2342
> now, for a given text-pre
hi,
i have a table, where there is a varchar(500) column,
which contains data that is strangely formatted:
it starts with letters, and ends with a number.
for example:
xyz001
xyz002
xyz044
xyz1243
abc01
abc993
abc2342
and so on.
now, for a given text-prefix (for example "xyz"), i need to
find
My environment setup as:
show lc_ctype;
lc_ctype
-
fr_CA.UTF-8
(1 row)
fis=> SELECT 'Ä' ~* 'ä';
?column?
--
f
(1 row)
fis=> SELECT 'Ä' ilike 'ä';
?column?
--
f
(1 row)
I got the same result: false
"=?ISO-8859-1?Q?Ragnar_=D6sterlund?=" <[EMAIL PROTECT
"=?ISO-8859-1?Q?Ragnar_=D6sterlund?=" <[EMAIL PROTECTED]> writes:
> I'm not sure if this is a bug or if I'm doing something wrong. I have
> a database encoded with ISO-8859-1, aka LATIN1. When I do something
> like:
> SELECT 'Ä' ~* 'ä';
> it returns false.
Check the database's locale setting (LC
Hi,
I'm not sure if this is a bug or if I'm doing something wrong. I have
a database encoded with ISO-8859-1, aka LATIN1. When I do something
like:
SELECT 'Ä' ~* 'ä';
it returns false. If i do:
SELECT 'A' ~* 'a';
I get true. According to specification, both should return true.
Anyone knows wh
On 9/11/06, Penchalaiah P. <
[EMAIL PROTECTED]> wrote:
Hi good morning to all….
I created some functions in my pgadmin… when I am
deleting those functions from that pgadmin its giving error…i.e
An ERROR has occurred
ERROR:function function_name1(character varying, charact
[SIGH]
I was getting the syntax wrong. Just using ON rathar than = fixed
the mistake.
Time to crash for the night (day?) it seems
Thanks for the replies; if I hadn't've figured it out myself they
would have pushed me in the right direction.
-JimC
--
James Cloos <[EMAIL PROTECTED]>
Robert Edwards <[EMAIL PROTECTED]> writes:
> Or is it possible, over the same connection, to change the database
> user? My understanding of the frontend/backend protocol is that this
> is not allowed.
It is possible to change users.
SET SESSION AUTHORIZATION ;
http://www.postgresql.org/docs/
Hi, Robert,
Robert Edwards wrote:
> Or is it possible, over the same connection, to change the database
> user? My understanding of the frontend/backend protocol is that this
> is not allowed.
Not on protocol level, but one level higher.
SET SESSION AUTHORIZATION ;
pg_dump uses this frequent
Hi, Robert,
Robert Edwards wrote:
> (this is my first post to this list...)
Welcome here. :-)
> I am wondering if Postgres, and/or SQL in general, has a facility to
> run a function at connection set-up time (after a successful connection
> attempt) and/or at session completion (or disconnect)?
Hi good morning to all….
I created some functions in my pgadmin… when I am
deleting those functions from that pgadmin its giving error…i.e
An ERROR has occurred
ERROR:function function_name1(character varying, character
varying, character varying, date, character varying) does
13 matches
Mail list logo
