Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Christopher Browne
[EMAIL PROTECTED] (Andrew Sullivan) wrote: > On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote: >> >> Do *any* databases implement SQL standard Assertions? > > Somebody must've had an implementation, or it'd never have made it > into the spec ;-) Supposedly, RDB had this feature... O

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Andrew Sullivan
On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote: > > Do *any* databases implement SQL standard Assertions? Somebody must've had an implementation, or it'd never have made it into the spec ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting o

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Gregory Stark
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Well, it's on the SQL standard, so we should look forward to > implementing (some form of) it some day. Do *any* databases implement SQL standard Assertions? -- greg ---(end of broadcast)--- TIP 5: do

Re: [SQL] UTF8 Vs Latin9 and valid encoding.

2006-08-30 Thread Marcelo .
Hello, Thanks for your reply. When I execute show client_encoding; I get UNICODE. However, up to know I was using pgAdmin III Query and EMS... you gave me the idea to use psql, where I noticed something interesting: \encoding UTF8 show client_encoding; UTF8 So this seems to be OK.. However

Re: [SQL] Error on function parameters

2006-08-30 Thread Anton de Wet
On Wed, 30 Aug 2006, Ezequias Rodrigues da Rocha wrote: Hi list I am doing an statement like this: select insertPoints('C', '123456789', 12.5, 1, 987700944005, 104) and get the following error: ERROR: function inserirpontos("unknown", "unknown", numeric, integer, bigint, integer) does n

Re: [SQL] Error on function parameters

2006-08-30 Thread Tom Lane
"Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> writes: > I am doing an statement like this: > select insertPoints('C', '123456789', 12.5, 1, 987700944005, 104) > My function is declared like this: > Function base.inserirPontos(char(1), varchar(255), numeric(12,2), int8, > int8, int8 ) ret

[SQL] Error on function parameters

2006-08-30 Thread Ezequias Rodrigues da Rocha
Hi listI am doing an statement like this:select insertPoints('C', '123456789', 12.5, 1, 987700944005, 104)and get the following error:ERROR:  function inserirpontos("unknown", "unknown", numeric, integer, bigint, integer) does not exist HINT:  No function matches the given name and argument typ

[SQL] Trigger with Stored Procedure [Client Points]

2006-08-30 Thread Ezequias Rodrigues da Rocha
Hi list,I have a table like this:Points-Idoperationvalueand another two tables like thisClient    Rule    ---id idname 

Re: [SQL] UTF8 Vs Latin9 and valid encoding.

2006-08-30 Thread Markus Schaber
Hi, Marcelo, Marcelo . wrote: > I receive the error msg: > ERROR: invalid UTF-8 byte sequence detected near byte > 0xf1 > > Isn't UTF-8 the same as UNICODE where it encapsulates > all other coding schemes including latin9? Yes, it is. But it seems that your client and the server disagree on t