Transactions (well, recently mysql allows them but using propietary
extensions), foreign key relationships, subqueries, stored
procedures/triggers. MySQL lacks all of these.
On the other side, postgres is only ported on *nix platforms, but you
can put cygwin/cygipc on Windows, if that is the c
Am Sonntag, 7. Juli 2002 20:40 schrieb teknokrat:
> Is there any way to work with tables etc, in plsql? Can i get a get
> a database handle to the local database? If not, is there any
> chance for this to be implemented in the near future?
I guess you mean plpgsql.
you dont need a database hand
I have a table with a reference constraint and an ON DELETE SET NULL action.
When this action triggers, I also want to update another field in the table,
actually a timestamp which should be set to NOW().
After reading some documentation it would seem a rule is the easiest way to
accomplish this.
Peter Eisentraut wrote:
> Kevin Brannen writes:
>
>
>>EXCEPT that now fails in 7.2.1 (I just upgraded this afternoon). It
>>forces me to use "b'00'" instead of "b'0'::bit(6)".
>
>
> Which is a problem why?
Because in the real system, it will be b'0'::bit(64) or b'001::bit(64)
or etc. A
Maybe I should explain my problem a little bit: simplified, I have two
tables, L and T, (which values references to L):
L:
art|kvvnr|semester
---+-+
7.0| 4151| 2002ws
7.0| 4326| 2002ws
6.1| 4200| 2002ws
7.0| 4151| 2001ws
(combination of kvvnr and semester is unique)
T:
id
On Sun, Jul 07, 2002 at 11:40:19AM -0700, teknokrat wrote:
> Is there any way to work with tables etc, in plsql? Can i get a get a
Yes.
> database handle to the local database? If not, is there any chance for
> this to be implemented in the near future?
I don't know what you mean. A PL/pgSQL f
On Sunday 07 Jul 2002 10:59 pm, Mirco D'Angelo wrote:
> Hi
>
> I am going to learn MySql 'cause I have to, but would it be better, or
> let's say, more interesting, to learn postgressql? Is it newer, more
> common, etc.?
Mysql is more common on web-hosting platforms, but you can find PostgreSQL i
That is because your query is generating a cartesian product.
Try:
SELECT (
SELECT SUM(totalprice)
FROM invoices
WHERE custnumber = '1'
) - (
SELECT SUM(paymentamount)
FROM payments
WHERE custnumber = '1'
)
Roy Souther wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
On Sun, Jul 07, 2002 at 11:59:51PM +0200, Mirco D'Angelo wrote:
> Hi
>
> I am going to learn MySql 'cause I have to, but would it be better, or let's
> say, more interesting, to learn postgressql? Is it newer, more common, etc.?
PostgreSQL is certainly more interesting, more useful, more
feature
Hi
I am going to learn MySql 'cause I have to, but would it be better, or let's
say, more interesting, to learn postgressql? Is it newer, more common, etc.?
greets
mirco
---(end of broadcast)---
TIP 6: Have you searched our list archives?
htt
Hello,
I would like to know if there are any global variables
storing the error code or the number of rows affected
after each execution of the SQL statement.
Also, for Postgresql function, I have checked that I
can only call the function by: select function(parms)
or by EXECUTE PROCEDURE functi
Is there any way to work with tables etc, in plsql? Can i get a get a
database handle to the local database? If not, is there any chance for
this to be implemented in the near future?
thanks
---(end of broadcast)---
TIP 2: you can get off all lis
Perhaps the 'create rule' is in the way, you could try something like:
CASE WHEN document_online THEN 1
ELSE 0
END,
CASE WHEN document_valid 1
ELSE 0
END
But if that doesnt work, I'm out of options aswel.
You could try the "instead query" separately to test whether the query
itself is corre
On Mon, Jul 08, 2002 at 03:18:33 +0200,
Joachim Trinkwitz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to insert a row only under condition that there isn't already
> another row with similar values -- something like a INSERT INTO
> ... WHERE NOT EXISTS (SELECT ...)?
You can do something like t
create an uniq index on the columns,
# create unique index index_name on table (col1,col2,col3,...)
hope it helps.
regds
mallah
On Monday 08 July 2002 06:48, Joachim Trinkwitz wrote:
> Hi,
>
> I want to insert a row only under condition that there isn't already
> another row with similar va
> The information you gave is not very helpful.
> An INSERT command, which caused the error, would help.
> Anyway, did you enclose the text by single quotes?
> AFAIK, you do not have to escape double quotes.
>
Found the problem. Yes I enclosed the text in single quotes, and the text
also i
The information you gave is not very helpful.
An INSERT command, which caused the error, would help.
Anyway, did you enclose the text by single quotes?
AFAIK, you do not have to escape double quotes.
Regards, Christoph
>
> Hi everyone,
>
> I have a column with type text and am trying to pu
Hi everyone,
I have a column with type text and am trying to pump in a larger amount of
text that has double quotes and also commas in between. I got an error
when I tried to do a simple INSERT. I then tried to escape the double
quote with a backslash but that didn't work. The manual for the 7.1
Hi,
Regarding temp tables in the same connection session. If there is SQL
procedure creating temp tables, process temp tables and drop all the temp
tables finally. This SQL procedure can't run twice in the same session.
Because all the temp tables are referred to the first physical temp tables.
I
19 matches
Mail list logo
