Isn't the simple answer to use bind variables?
SQL using bind variables instead of making a new SQL string each time will
prevent malicious users from invoking functions and inserting other sql, as
well as handle the original problem regarding storage of newlines vs \n.
I don't know much about Po
On Thu, Dec 18, 2003 at 12:21:35 +,
teknokrat <[EMAIL PROTECTED]> wrote:
> I am after an sql query that can give the differnces between consecutive
> timestamp values in the resultset.
> anyone know how to do this?
I think you can do something like the following (untested) on most systems.
s
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> I'm interested in hearing what others have to say, especially along the
> lines of implementation. I haven't seen much discussion of distributed
> keys on the lists (other than Josh Berkus), so perhaps there isn't much
> interest. Would there be a
Hello all!
An area of the relational database model that is not included in the
SQL standard are distributed keys and distributed foreign keys. A quick
example (Case 1):
employees (id, name);
schools (name, location);
teachers (employee_id, school_name);
subs (employee_id);
managers (employee_i
...Postgresql 7.2...
I'm building the history of a table using rules. I've been trying to figure out
a way to select on a table as it would have appeared in a point in time. I
can't seem to wrap my brain around the problem, tho.
Given some tables
CREATE TABLE list (
num int4 NOT NULL,
name
Hi Pedro;
I understand that at the moment it is more of a design limitation than a
bug. I think we should vote the desired behavior as a feature request,
however.
Best Wishes,
Chris Travers
- Original Message -
From: "Pedro" <[EMAIL PROTECTED]>
> >> Foreign keys, unique and primary key
Ð ÐÐÐ, 22.12.2003, Ð 18:53, scott.marlowe ÐÐÑÐÑ:
> 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 abou
On Tuesday 23 December 2003 05:49, vijaykumar M wrote:
> 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 i
