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
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.
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
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
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
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
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
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
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
