Re: [SQL] Temporary tables

Thanks to all of you for your suggestions. the problem is solved by creating a function istableexist() that returns whether a table exist or not. the function is bellow. CREATE FUNCTION istableexist(varchar) RETURNS bool AS '  DECLARE  BEGIN      /* check the table exist in database and is visible

Re: [SQL] insert error

Hi all, I am getting the following error while executing insert command inserting data in master database after I have started the erserver. I did not get this error when erserver was not started. Also, I am not getting the error in slave database when inserting as may be the column _ers_uniq is s

Re: [SQL] Especial delimiters caracter

> > Thanks for your replay... > I resolve the problem with sed before i post the question. > But a really want to know if i can handle all with posgre script. > > Mariano > No, you cannot. Because copy is also intended to work vice versa i.e. copy from file to table and therefore the doubled ba

Re: [SQL] SQL Syntax problem

Hi Doris, In oracle (+) is left outer join or right outer join . You need to write: select... fromauswahlkatalog k, beteiligter b left outer join anspruchkorrektur a on(b.bet_id = a.bet_idemp) left outer join v_betkorr f on (a.ask_id = f.ask_id) where k.awk_id = a.awk

Re: [SQL] Change of the datatype of a column

> > How is that I can alter the datatype of the column . > Search the archives on that topic. There should be numerous posts about how to achieve that. Regards, Christoph ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [SQL] SQL Syntax problem

sad wrote: select... fromauswahlkatalog k, anspruchkorrektur a, beteiligter b, v_betkorr f where k.awk_id = a.awk_id and b.bet_id(+) = a.bet_idemp and a.ask_id = f.ask_id(+) This (+) means JOIN Means OUTER JOIN but I don't remember the side. e.g.