Hello everybody out there using PostgreSQL,
A table with the results of students in different exams
student | date_of_exam | grade
--
Peter | 2010-09-09 | 2
Tom | 2010-09-09 | 1
Andy| 2010-09-21 | 3
Tom | 2010-09-21 | 4
Peter | 2010-09-21 | 1
Am 17.01.2011 00:20, schrieb Steve Litt:
On Sunday 16 January 2011 17:40:34 Julia Jacobson wrote:
Hello everybody out there using PostgreSQL,
A table with the results of students in different exams
student | date_of_exam | grade
--
Peter | 2010-09-09 | 2
Tom
Hello everybody out there familiar with the tablefunc module,
Having read the documentation of the tablefunc module,
I'm wondering whether it is possible to get the values for the names of
the columns for the crosstab query from a subquery.
A minimal example would look like this:
CREATE TABLE
ion
list must not only contain the name of the column but of course also a
data type (always the same - int).
Is it possible for a newbie to solve my problem by a user-defined
function in PL/pgSQL or is it rather complicated?
On 01/21/2011 16:08, Joe Conway wrote:
On 01/21/2011 05:48 AM, Jul
Dear PostgreSQL community,
Please consider the following minimal example:
CREATE TABLE example (row_id SERIAL, value TEXT);
INSERT INTO example(value) VALUES ('val1');
INSERT INTO example(value) VALUES ('val2');
INSERT INTO example(value) VALUES ('val3');
CREATE OR REPLACE FUNCTION foo()
RETURN
Dear PostgreSQL community,
When trying to compile c++ code including libpq against the static
version libpq.lib, Visual Studio 2010 gives me the following errors:
1>main.obj : error LNK2019: Unresolved external reference "__imp__exit"
in Funktion "_main".
1>libpq.lib(fe-connect.obj) : error L
Thanks for your answer. I was indeed using the static libpq version from
the installer.
I tried to compile my own one with Visual Studio 2010, but this caused a
lot of problems due to the fact that Visual Studio 2010 has changed the
manifest tool.
So I built a static version using Visual C++ 200
, Feb 27, 2011 at 19:00, Magnus Hagander wrote:
On Sun, Feb 27, 2011 at 18:01, Julia Jacobson wrote:
Thanks for your answer. I was indeed using the static libpq version from the
installer.
I tried to compile my own one with Visual Studio 2010, but this caused a lot
of problems due to the fact
My application looks like this:
#include
#include "libpq-fe.h"
using namespace std;
int main(void)
{
PGconn *conn;
const char *info = "hostaddr = 'postgres.server.com' \
port = '5432' \
dbname = 'mydb' \
user = 'us
Okay, I could fix it by myself now:
One has to tell Visual C++ to ignore msvcrt.lib.
A warning message during the compilation of my code already lamented a
conflict between msvcrt and the included libraries.
I should have taken it for serious instead of just ignoring it.
So now everything works
Hi,
Although I finally managed to build libpq using Visual C++, I'm
continuously experiencing problems with this IDE.
Therefore I switched to MinGW and it was indeed easy to compile libpq
with it from the first time on.
However, I'm experiencing the same problem as discussed on
http://archives
Hello everybody out there using PostgreSQL,
One of the tables in my database contains pictures in jpeg format in a
column of the type BYTEA.
I have written a script in Python for inserting pictures into the
database as well as exporting them from the database later. It works fine.
When running p
Hello everybody out there using PostgreSQL,
What is the problem with the following C++ code for the extraction of
data from a BYTEA column to a binary file?
#include
#include
#include
#include
#include "libpq-fe.h"
using namespace std;
main ()
{
PGconn *conn;
conn = PQconnectdb("hosta
Hello everybody out there using PostgreSQL,
After having read the official documentation and having done extensive web
search, I'm wondering how to perform something like a SELF LEFT OUTER JOIN in
PostgreSQL, i.e. a SELF JOIN on a table containing NULL values in one of the
columns to join.
Tha
14 matches
Mail list logo
