I do not try,
may be it exists different languages to make this in postgresql :
I make this in pl/pgsql, I do not have time to make this in C,
CREATE OR REPLACE FUNCTION "_replaceblock" (text, text, text) RETURNS
text AS'
DECLARE
text_begin ALIAS FOR $1 ;
key_name ALIAS FOR $2 ;
key_val
I try to reencode postgresql db ... all is running ... in your shell :
- pg_dump db -f fileout
- iconv fileout i do not remember parameters but iconv converts the
file.
- createdb db -U unicode (for example)
- pgsql db < fileout_converted
We change previous year the encoding of this webs
I try pgmail and that is well running ...
fo security, do not use attachment files with your mail ...
try pgmail, you need to use pl/tclu ...
Ben
Sai Hertz And Control Systems wrote:
Dear Uzo ,
Hi,
does postgresql support the ability to email as in SQL Server? I want
to create a trigger which
Oh dear a man using CF with postgresql ! ... OH YES ! ...
try to use jdbc pilot to connect to postgresql with CFMX ...
maybe you can use cfstoredproc with cfprocparam and cfprocrsult
Roberto Mello wrote:
On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote:
Hi,
How to call Pos
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
George Essig wrote:
hi
I have menu table:
id | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
comment on table "test"
is 'fziofeiozfiezojfezjfeziojfeziojf ezfjioezifj ezio' ;
Rod Taylor wrote:
On Wed, 2003-08-13 at 07:56, [EMAIL PROTECTED] wrote:
Hi,
I want to insert descriptions at the columns of my tables but without
using the command COMMENT ON. I want to do it to
No trigger
Just triggers for foreign key in spectacle and none in spectacle_v
How is it possible to verify triggers for foreign keys ?
Stephan Szabo a écrit:
On Fri, 8 Aug 2003, BenLaKnet wrote:
When I duplicate this code in an other table named spectacle_v without
Foreygn
we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.
But I think all of triggers of referenced table are not deleted.
We recreate the schemas ... and now is running.
How is it possible to identify Triggers with no referenced tables ?
Stephan Sz
ower.net/rjhalljr/Serve/MySQL/traer.html
http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=adjacency+list+%2B+tree+%2B+joe
On Wednesday 09 Jul 2003 8:57 pm, Benoît Bournon wrote:
I have to make a function that returns a tree with title and link of a
table.
Recursively, a in
vinfo/DBMSTrees/sqltrees.html
http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html
http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=adjacency+list+%2B+tree+%2B+joe
On Wednesday 09 Jul 2003 8:57 pm, Benoît Bournon wrote:
I have to make a function that retu
I have to make a function that returns a tree with title and link of a
table.
Recursively, a information depends on a parent information.
It is to organise a menu with parent dependance.
How is it possible and faster ? in C ? pl/pgsql or other ?
---(end of broadcast)--
I have to use PREPARE statement, I have just read an article that this
function is not implemented in 7.3 version ?
is it correct or not ?
If I must tu upgrade my server :
I install different languages in databases, must I reinstall all of them
after upgraded ?
Ben
--
Thx to Staphan
Finally I find a solution :
I have tables with different languages and I must find the correct
languages :
DECLARE
chaine VARCHAR := 'category';
col_return VARCHAR := 'id_category_unique' ;
col_id VARCHAR := 'id_category' ;
col_value INTEGER := 5 ;
lang_id INTEGER := 3
I can do that on PostgreSQL 7.3 ??
Is it possible to do that ? or must I upgrade my server ??
PREPARE q1(text) FROM SELECT * FROM pg_tables WHERE tablename = $1 ;
EXECUTE q1 USING 'client' ;
DEALLOCATE q1 ;
---(end of broadcast)---
TIP 3: if po
14 matches
Mail list logo
