[SQL] privileges

Hi all can anyone give me a link to a Reference manual which describes all privileges on any DB object and it's meaning :-) thnx. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Problem with Escape charactor

Dear Friends,   I am working with Postgres 7.3.4 on RH Linux 7.2 . I am executing a dynamic query inside a PL/pgSQL procedure and I am having the following problem.   While a line in the PL/pgSQL function is like the following     EXECUTE 'update "WATS".action_plan_master set rec_deleted_fla

[SQL] Interest query plan

Hi all, I am running pg 7.3.1. My query is very simple but pg generates not the best possible plan for me: analyze select * from a_doc D left outer join (A_SKLAD S join A_MED M ON(S.IDS_MED=M.IDS) )on( d.IDS=s.IDS_DOC) where d.IDS='SOF_700060'; The plan is: -

Re: [SQL] Interest query plan

Hi all, I am running pg 7.3.1. My query is very simple but pg generates not the best possible plan for me: analyze select * from a_doc D left outer join (A_SKLAD S join A_MED M ON(S.IDS_MED=M.IDS) )on( d.IDS=s.IDS_DOC) where d.IDS='SOF_700060'; What about: select * from a_doc D left join A_SKLA

Re: [SQL] Interest query plan

explain analyze select * from a_doc D left outer join A_SKLAD S ON(D.IDS=S.IDS_DOC) left join A_MED M ON(S.IDS_MED=M.IDS) where d.IDS='SOF_700060'; QUERY PLAN --

Re: [SQL] Interest query plan

I have also another good example for a slow left join work. Can I do it better? explain analyze select * from a_doc D join A_SKLAD S ON(D.IDS=S.IDS_DOC) join A_MED M ON(S.IDS_MED=M.IDS) where d .date_op >= 9600 and d.date_op <= 9700; QUER

Re: [SQL] Interest query plan

I have also another good example for a slow left join work. Can I do it better? explain analyze select * from a_doc D join A_SKLAD S ON(D.IDS=S.IDS_DOC) join A_MED M ON(S.IDS_MED=M.IDS) where d .date_op >= 9600 and d.date_op <= 9700; -> Seq Scan on a_doc d (cost=0.00..13145.43 ro

Re: [SQL] Problem with Escape charactor

Kumar,   Have you tried   EXECUTE 'update "WATS".action_plan_master set rec_deleted_flag =  \'Y\' WHERE action_plan_id IN ('|| p_action_plan_ids || ')';^  ^   HTH, George - Original Message - From: Kumar

Re: [SQL] privileges

Sad, > can anyone give me a link to a Reference manual > which describes all privileges on any DB object and it's meaning :-) > thnx. http://www.postgresql.org/docs/7.3/static/sql-grant.html http://www.postgresql.org/docs/7.3/static/user-manag.html -- Josh Berkus Aglio Database Solutions San Fr

[SQL] row and column transposition

Anyone know some sql that display a row as a set of rows with column name vs column value? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[SQL] PG equivalent to Sybase varbinary

Anybody know what the Postgresql equivalent to a Sybase varbinary data type is? I have a package that provides ddl to store a 40 byte/char? varbinary column in a table and it is failing against postrgresql. Thanks for any help and if more info is need to answer, please let me know. Bill Pfeiffer

[SQL] Bad encoding in URL

Hi I have some URLs in a database but some of the URL contain %3A and so on.. Is there an easy way of converting '%3A' to ':' ??? I cannot find any replace(String str, String str) among the string functions. ThankYou. ---(end of broadcast)--- T

Re: [SQL] row and column transposition

On Mon, Oct 06, 2003 at 14:28:39 +0100, teknokrat <[EMAIL PROTECTED]> wrote: > Anyone know some sql that display a row as a set of rows with column > name vs column value? contrib/tablefunc provides a crosstab function that should do what you want. ---(end of broadcast)

Re: [SQL] Bad encoding in URL

Maybe you want to look here: http://www.brasileiro.net/postgres/cookbook/ mimic oracle's replace function. versions in pltcl and plpgsql. If the function you want isn't built in to posgresql... Ted --- HR <[EMAIL PROTECTED]> wrote: > Hi > > I have some URLs in a database but some of the URL

Re: [SQL] Bad encoding in URL

>From the manual: replace(string text, from text, to text) text Replace all occurrences in string of substring from with substring to replace('abcdefabcdef', 'cd', 'XX') abXXefabXXef HTH. George - Original Message - From: "HR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Mo