[SQL] small problem

hi to all I am doing a webpage and i manipulate data from a postgres database. I need to do the same thing with a oracle database. I am using pg_dump to transfer the database data from postgres to oracle but there are a few problems with same data types in a table when i try to import it to a ora

[SQL] small proble

hi to all I am doing a webpage and i manipulate data from a postgres database. I need to do the same thing with a oracle database. I am using pg_dump to transfer the database data from postgres to oracle but there are a few problems with same data types in a table when i try to import it to a ora

Re: [SQL] small problem

create table (...) (...) duration interval default 7 do you really think it's worth spending 12 bytes for your intervals? i usually use either timestamps or integers for intervals. btw, as i know default 7 would be 7 msecs :) hourDaytimestamp with time zome consider using it without a tim

[SQL] bigger problem

in postgres database i created a table with a field like create table (...) (...) var text default '' not null (...) now i need to import the data from this table into a oracle database i used pg_dump I altered the field data type to (...) var varchar2(50) default '' not null (...) but when i

Re: [SQL] Generating a cross tab (pivot table)

> I saw something that might somewhat a bit more > flexible solution using SQL. I don't know if it works > in PostgreSQL. I saw it at the MySQL site. > > The following is the URL: > http://www.mysql.com/articles/wizard/index.html > > Has anyone tried this on a PostgreSQL database ? No, not

[SQL] Generating a cross tab II (pivot table)

Based on the e-mails on "Generating a cross tab (pivot table)", I can give you a PLpgSQL procedure to automatically generate a cross tab from any relation now. It's my first steps in PLpgSQL. I am pretty sure this is not the best way to implement, but I wanted to get some experience, so I d

Re: [SQL] Permission on insert rules

On Fri, 2002-11-08 at 21:40, Bruce Momjian wrote: > Josh Berkus wrote: > > > > Luis, > > > > > Just a question. > > > I'm writing some rules to insert/update some data in my database, and I > > > gave all the privileges on that view to the user, and only select on the > > > tables. > > > When t

Re: [SQL] Permission on insert rules

Robert, > If the functions can fire as there creator instead of there caller, > then > I would think as long as the creator has insert/update views on the > base > table, you should be able to do updateable rules and give only > permissions to the view for the caller. (Though maybe you have to use

Re: [SQL] bigger problem

Carlos, > in postgres database i created a table with a field like > > create table (...) > (...) > var text default '' not null > (...) > > now i need to import the data from this table into a oracle database > i used pg_dump > > I altered the field data type to > > (...) > var varchar2(50) d

Re: [SQL] Generating a cross tab (pivot table)

Christoph, Lud, > > I saw something that might somewhat a bit more > > flexible solution using SQL. I don't know if it works > > in PostgreSQL. I saw it at the MySQL site. > > > > The following is the URL: > > http://www.mysql.com/articles/wizard/index.html > > > > Has anyone tried this on a

Re: [SQL] bigger problem

Carlos Sousa writes: > (...) > var varchar2(50) default '' not null > (...) > > but when i was importing the the table into the oracle database all the rows > with the field var='' were not inserted. > Is there a way to work this around Yes, don't use Oracle. In Oracle, '' is the same as null, s

Re: [SQL] Permission on insert rules

Luis, > Just a question. > I'm writing some rules to insert/update some data in my database, and I > gave all the privileges on that view to the user, and only select on the > tables. > When that user inserts data using the view, I thought that was user > postgres that will do the rest ! But I

[SQL] pg_dump / dates:

Question for Tom Lockhart: pg_dump is generating some dates that look like: '2002-09-09 02:11:60.00' or '2002-10-31 23:59:60.00'. psql -f doesn't like these dates. I can sed the :60 to a :59 but -- in the latter case it moves the date backwards a day, which doesn't work for my app. I underst

[SQL]

HI, Can someone pls help us with the following problem? Any help would be appreciated. Regards -Naren. Is stored procedures will return muliple rows in postgresql. If so a sample example is needed. This message is proprietary to Hughes Software Systems Limited (HSS) and is intended