D'oh sorry for the subscribe message to the list...
Greetings, I am new to PostGreSQL and the advanced capabilities that it
offers. I would like to create a joined view that allows inserts and
updates on two different tables (but, joined twice).
Suppose you have:
create table user {
name
mikeo <[EMAIL PROTECTED]> writes:
> after about 50,000 updates, which fly right along, the process begins
> to really bog down. we perform a vacuum analzye and it speeds right
> up again.
A plain "vacuum" should do the job in a bit less time. The problem
is you need to reclaim the space occupie
I read from messages like
http://www.postgresql.org/mhonarc/pgsql-sql/1999-11/msg00076.html that CURSORS could
not be used with pg/plsql, and indeed attempting to do so result in the same kind of
error highlighted in that message.
Are there any other ways I could with pgplsql simuate the use of
Hello!
Well, I have a need for an OUTER JOIN, but have semi-solved it by using
a UNION. However, I can't do an ORDER BY on a UNION, and have since
discovered that a VIEW can not be used with a UNION.
Is there another way (possibly with one or more FUNCTIONs), for me to get
this join on two tabl
hi,
we have a weird situation here. we have a table of approx. 10k rows
representing accumulated activity by specific customers. as information
is gathered those customers rows are updated. the number of rows does not
increase unless we get a new customer so that is not a factor. the table
Shouldn't we have links to these on our web site?
> De Moudt Walter wrote:
>
> > Stoyan
> > The only reference I found is at http://www.ansi.org
> > They guard the standard. But they charge you for reviewing the document
> > :-( and it's not cheap either
> > a search on sql-92 delivers a huge r
Adam -
Looks like it was renamed to strpos() in 7.0. A quick compatability
hack to get up and running until you can rewrite the code would be to
do something like:
CREATE FUNCTION textpos (text,text) RETURNS int AS 'SELECT strpos($1,$2)'
LANGUAGE 'SQL';
Now all your old code will work, just a
I am trying to convert my C++ data types into SQL Server data types. I
found a short list on Microsoft's website, but it did not list all of the
types. I was wondering if you could give me a list of the conversions or
could direct me where to go.
Hello,
I'm looking for data modelling software tools, and at first glance I'm
not sure about what logic model is more appropiated.
Database books usually refer to the E-R model, but UML is a more general
approach. I've tried an old release of ERWin (2.5), and Assimetrix
Infomodeller 1.5, which n
