StackOverflow Questions for Tag: postgresql-8.0

Matt
Matt

Reputation: 15071

Combining stv_tbl_perm, pg_class and stl_query to get queries ran against tables with 0 rows RedShift SQL PostgreSQL

Score: 0

Views: 96

Answers: 2

Read More
Matt
Matt

Reputation: 15071

Remove duplicate values in the same column in PostgreSQL

Score: 0

Views: 80

Answers: 1

Read More
D D
D D

Reputation: 1

How to limit group by statement to 1 column

Score: 0

Views: 38

Answers: 2

Read More
Benedict K.
Benedict K.

Reputation: 37

... WHERE ['ID_two','ID_four'] COINTAINS_AT_LEAST_ONE_ID_FROM ['ID_one','ID_two','ID_three']

Score: 0

Views: 42

Answers: 1

Read More
Dharam
Dharam

Reputation: 153

REDSHIFT: How can I generate a series of numbers without creating a table called "numbers" in redshift (Postgres 8.0.2)?

Score: 4

Views: 23816

Answers: 4

Read More
Bikas Katwal
Bikas Katwal

Reputation: 2035

Query to collapse records if record is substring and falls in a time interval

Score: 0

Views: 38

Answers: 0

Read More
Indy
Indy

Reputation: 75

SQL- Return rows after nth occurrence of event per user

Score: 1

Views: 548

Answers: 3

Read More
luisfelipe18
luisfelipe18

Reputation: 597

syntax error at or near "(" postgresql + Python

Score: 0

Views: 558

Answers: 2

Read More
peednas7077
peednas7077

Reputation: 1

Rollup data hierarchy in postgresql 8.0?

Score: 0

Views: 358

Answers: 1

Read More
Cow
Cow

Reputation: 99

How to convert unix_timestamp interger in psql?

Score: 0

Views: 822

Answers: 2

Read More
Chetan Pagar
Chetan Pagar

Reputation: 1

Need Sorting With External Array or Comma Separated data

Score: 0

Views: 83

Answers: 1

Read More
Wired604
Wired604

Reputation: 370

SAS to PostgreSQL(PADB) code - summing field if they exists

Score: 0

Views: 52

Answers: 1

Read More
softdevlife
softdevlife

Reputation: 98

When replicating tables, what is the best way to mirror removed records from original table?

Score: 0

Views: 44

Answers: 0

Read More
Georgi Bonchev
Georgi Bonchev

Reputation: 300

SSL connection error in PostgreSQL 8.0

Score: 3

Views: 4499

Answers: 2

Read More
alarson008
alarson008

Reputation: 3

how can I use window function - difficult case in PostgreSQL

Score: 0

Views: 552

Answers: 2

Read More
Himanshu Dhingra
Himanshu Dhingra

Reputation: 367

sql Find the pattern and count how many times it appeared

Score: -3

Views: 315

Answers: 2

Read More
Henry
Henry

Reputation: 721

Date intervals in Postgresql not showing correct results

Score: 0

Views: 132

Answers: 1

Read More
Berra2k
Berra2k

Reputation: 328

Redshift PostgreSQL Distinct ON Operator

Score: 6

Views: 9631

Answers: 2

Read More
ramya
ramya

Reputation: 275

Optimized querying in PostgreSQL

Score: 1

Views: 68

Answers: 1

Read More
PreviousPage 1Next