Hi
Please help me compose the query in PostgreSQL.
Using PostgreSQL 7.1.2.
Suppose relations A and B have columns:
{X1, X2, ..., Xm, Y1, Y2, ..., Yn}
and
{Y1, Y2, ..., Yn}
Attributes Y1, Y2, ..., Yn are common for both relations
and have the same type in both.
How can I define in
Hi
The following is the quote describing WHERE clause of SELECT
(pgsql/doc/html/sql-select.html).
WHERE Clause
The optional WHERE condition has the general form:
WHERE boolean_expr
boolean_expr can consist of any expression which evaluates to a boolean value. In many
cases,
this
Hello
Consider two simple tables: AA, BB.
proba=# \d aa
Table aa
Attribute | Type | Modifier
---+-+--
id| bigint |
val | integer |
proba=# select * from aa;
id | val
+-
1 | 1
2 | 2
2 | 2
3 | 3
3 | 3
3 |
Hello
I see the following
proba= select * from pg_language;
lanname |lanispl|lanpltrusted|lanplcallfoid|lancompiler
+---++-+--
internal|f |f |0|n/a
lisp|f |f |
Hello all,
Please help me with
create function days_in_month(int4, int4, int4) returns int4
as '/tmp/days.so' language 'c';
Can I write this function days_in_month in C++ ?
I've did the following:
extern "C" {
int days_in_month(int year, int mo, int day);
}
extern "C" {
int