[SQL] Pgaccess problem on RedhatLinux9

Hi All, Previously i was used RedhatLinux7.2 & Postgres7.4, that time i'm able to use the pgaccess command to view the tables. Presently, i'm using RedhatLinux9 & Postgres7.4, here i'm not able to use the pgaccess command. It is saying "command not found." One thing, i observed was on R

Re: [SQL]

> I am new of postgre sql.im using cursors in pgsql and > getting tuples successfully returns in c++, but how > can i raise exception in the stored function?.pl > anyone help me. You can use 'raise exception' for this purpose. Refer this link for details: http://www.postgresql.org/docs/current/int

Re: [SQL] Crosstable query

On Dec 19, 2003, at 8:41 AM, Dok, D. van wrote: MS Access has a 'TRANSFORM' function to do this, which transposes the data along a pivot. You'll probably want to look at Joe Conway's tablefunc. It's in contrib. It's included in 7.4; I'm not sure about 7.3.4, but you can add it if it's not. Hope

Re: [SQL] [JDBC] Insert Row to ResultSet problem....java.sql.SQLException: No Primary Keys

On 16/12/2003 15:24 Jason L. van Brackel wrote: [snip] . this is where I get this exception java.sql.SQLException: No Primary Keys ~~~ at org.postgresql.jdbc2.AbstractJdbc2ResultSet.isUpdateable(AbstractJdbc2ResultSet.java:1363) at org.postgresql.jdbc2.A

Re: [SQL] SQL Optimization

"Preeti Ambardar" <[EMAIL PROTECTED]> writes: > SELECT ... > FROM mstuserprofiles cpuser RIGHT OUTER JOIN mstcompanies > ON cpuser.fktrdid_usptradhouseid = mstcompanies.fktrdid_cmptradhouseid > AND cpuser.pkuspid = mstcompanies.cmpcontact_userid > LEFT OUTER JOIN mstcurrency > ON mstcompa

[SQL] Crosstable query

Hello, I'm writing this bit because it adresses a common problem, but uses a different solution. In a simple data model of timeseries, we have a table with fields v (for variable), t (for time) and y (the data value). v,t is the primary key. It is sometimes desireable to have a side-by-side comp

[SQL]

hi, I am new of postgre sql.im using cursors in pgsql and getting tuples successfully returns in c++, but how can i raise exception in the stored function?.pl anyone help me. This is my function : CREATE or REPLACE FUNCTION sp_test_validatePartnerCode(text) RETURNS int4 AS ' DECLARE

[SQL] SQL Optimization

I am working on a query qhich has lot of RIGHT and LEFT Outer joins. This takes almost 2 hours to execute. SELECT mstcurrency.pkcurid, mstcurrency.curswift_code, mstproducts.pkprdid, mstproducts.prdname, mstproducts.fkcnvid_prdbaseuom, cpuser.uspname || ' ' || cpuser.uspsurname as uspnam

[SQL] Problem with functions.

Hi, I'n trying to create a function with two input values and returning a SETOF. When I only have one input value everything is working ok. If I instead create the same function with two input values the query fail with: ERROR: a column definition list is required for functions returning "recor

Re: [SQL] INHERITS and Foreign keys

Foreign keys, unique and primary key constraints do not meaningfully inherit currently. At some point in the future, that's likely to change, but for now you're pretty much stuck with workarounds (for example, using a separate table to store the ids and triggers/rules on each of the tables in the

[SQL] restoring database

Hi everybody ... i need to restore only one database from a pg_dumpall backup file... how can i do it? Thanks a lot ! -- Lucas Lain Gerencia de Ingeniería TechTel Telecomunicaciones [EMAIL PROTECTED] TE. (54-11) 4000-3164 ---(end of broadcast)--

Re: [SQL] testing for null value in integer field?

try: column is null, as manual shows. Geoffrey wrote: How does one check for an unset value in an integer field? I've tried such things as: select . where intnumber = '' select .. where intnumber = ? select . where intnumber = NULL Thanks. C. ---(end of

[SQL] INDEX and NULL values

Here are the sample tables for my question. CREATE TABLE bar ( idint2 PRIMARY KEY UNIQUE DEFAULT nextval('bar_id_seq'), ... ); CREATE TABLE foo ( idint2 PRIMARY KEY UNIQUE DEFAULT nextval('foo_id_seq'), numberint2 NOT NULL, bar_idint2 REFERENCES bar ON

[SQL] Returning Setof Record Dynamically

Hi,   I am attempting to use Setof Record dynamically. I am developing an application where I will not know what the end-user is trying to work with from a web front end. Thus I will not know before hand the structure of the table I am trying to pull the record from.   My Code:   CREATE FUNCTION re

[SQL] how do i get differences between rows

I am after an sql query that can give the differnces between consecutive timestamp values in the resultset. anyone know how to do this? thanks ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] restoring database

On Mon, 22 Dec 2003, Theodore Petrosky wrote: > As I am not someone with a lot of experience > (depending on the size of the 'dumpall') I would > create a new database to suck up the 'all' then > pg_dump the table I really cared about. > > Obviously, if the dump_all is a terabyte database th

Re: [SQL] restoring database

As I am not someone with a lot of experience (depending on the size of the 'dumpall') I would create a new database to suck up the 'all' then pg_dump the table I really cared about. Obviously, if the dump_all is a terabyte database this method is inconvenient (to say the least). However

[SQL] restoring database

Hi everybody ... i need to restore only one database from a pg_dumpall backup file... how can i do it? Thanks a lot ! ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [SQL] Get x from point?

On Mon, Dec 22, 2003 at 04:54:01PM +0800, Daniel Lau wrote: > I am wondering if we are able to extract the x-coordinate from a > point-type attribute with SQL. I have been looking for this sort of > functions from documents and websites but it seems the function does not > exist. Or, any altnernate

Re: [SQL] how to preserve \n in select statement

On Monday 22 December 2003 09:37, Denis wrote: > Hi Richard.. > > If your users are required to fire only SELECT and no DML, you can do the > following: > > BEGIN; > execute the statements given by user > ROLLBACK; > > This will not affect your SELECT and also if any malicious user gives > DELETE s

Re: [SQL] how to preserve \n in select statement

Hi Richard.. If your users are required to fire only SELECT and no DML, you can do the following: BEGIN; execute the statements given by user ROLLBACK; This will not affect your SELECT and also if any malicious user gives DELETE statement, that will not have any impact too.. HTH Thanx Denis

Re: [SQL] how to preserve \n in select statement

On Saturday 20 December 2003 17:58, Matt Van Mater wrote: > > I readily admit that I didn't read much into it, but I think you are > mistaken. If you look at the following links you will see that postgresql > definitely had a vulnerability that allowed sql injection through the use > of escape cha

[SQL] Get x from point?

Hi all, I am wondering if we are able to extract the x-coordinate from a point-type attribute with SQL. I have been looking for this sort of functions from documents and websites but it seems the function does not exist. Or, any altnernate to do so? regards, Daniel Lau Hong Kong University of Sci