[GENERAL] Urgent help needed- alias name in update statement

Hello, In postgre, when i am trying to give alias name in update statement like below - - update mytable x set x.name = 'asdf' where x.no = 1 --- is giving error - mytable is not having col x. We have migrated code from oracle to pos

Re: [GENERAL] Can we overload = operator to word numeric = text

Dear Pavel, Thanks a lot... It worked. Regards, Venkat From: Pavel Stehule To: venkatra...@tcs.com Cc: pgsql-nov...@postgresql.org, pgsql-general@postgresql.org Date: 03/09/2010 04:07 PM Subject: Re: [GENERAL] Can we overload = operator to word numeric = text 2010/3/9 : > > Hello, > > We

[GENERAL] Can we overload = operator to word numeric = text

Hello, We have migrated oracle database to postgre. In oracle char to numeric type conversion is explicit (i.e. we can compare char = numeric); but in postgre it is throwing errors. There are so many functions - around 2000, and we can not go and do explict type casting in every function , wh

[GENERAL] How to read oracle table's data from postgre

Hello , I want to read oracle database table data from postgre. (like in oracle we can use database links, is there something like this available in postgre). I tried below - select dblink_connect('host=.., dbname=..user=.. pwd=..'); but it is giving error database refused connection. Do i ne

[GENERAL] How to find details of arguments in all functions in postgre - One solution

Hello All, I was trying to find some way, to list out all argument details in all functions in postgre(input parameter names, types and mode - in/out). I found one solution - -- select r.routine

Re: [GENERAL] [NOVICE] Is there any oracle user_source table equivalent in postgre?

stgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz [attachment "signature.asc" deleted by Venkatrao B/HYD/TCS] =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain conf

Re: [GENERAL] [NOVICE] Is there any oracle user_source table equivalent in postgre?

Thanks Thomas for your reply. when i am trying - select * from pg_catalog.pg_proc.prosrc i am getting error - cross database reference is not implemented. Also i am not able to see this table under pg_catalog node in pgAdmin tool. Same thing is happening with pg_catalog.pg_views.definition. Ca

[GENERAL] Is there any oracle user_source table equivalent in postgre?

Hello, Can any one help me if oracle like any user_source table is there in postgre 8.4 (in pg_catalog or information_schema). Actually we migrated code from Oracle to Postgre. Now i want to search in how many places( i.e. in functions ) we have used a particular syntax( e.g. current_date). Thi

Re: [GENERAL] One solution for Packages in Postgre

Thanks a lot Jayadevan. I was unaware of temp table kind of functionality exists in postgres. Now i updated functions as follows- I have one question - if is there any better way of checking if temporary table already created for the given session package(other than one i used to capture as exc

[GENERAL] One solution for Packages in Postgre

Hi Posgre Developers, I am new to Postgre. We are migrating an oracle db to postgre. In oracle we have used so many packages. As per my understanding, there is no oracle package like functionality in postgre. I was just trying to find some way to migrate ocale packages to postgre. Please let m