Hello
I see the following
proba=> select * from pg_language;
lanname |lanispl|lanpltrusted|lanplcallfoid|lancompiler
+---++-+--
internal|f |f |0|n/a
lisp|f |f |0|/usr/ucb/lisz
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 |
Hi
Would you mind to tell me how the DIVIDEBY operator could be
defined (the way Codd E.F [1] or Date C.J [2] define it) in
PostgreSQL ?
Using PostgreSQL 7.1.2
Thanks in advance.
1 Codd E.F. Relational Completeness of Data Base Sublanguages
2 Date C.J. An Introduction to Database Systmes 6th
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 PostgreSQL
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 expr
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 days_in_month(in
