Bayt.com

Trending PostgreSQL Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Web Development
PostgreSQL
PHP
SQL
Software Engineering
Zaid Rabab'a's image
Question added by Zaid Rabab'a Software Development Team Leader Al-Safa Co. Ltd.
11 years ago

How do I get 0 instead of null in this query?‎

Answers:
20
Followers:
Views:
466
Vote Count:
7
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
PostgreSQL
PHP
Software Engineering
Zaid Rabab'a's image
Question added by Zaid Rabab'a Software Development Team Leader Al-Safa Co. Ltd.
11 years ago

How do I find second highest value from a table?‎

Answers:
5
Followers:
Views:
148
Vote Count:
8
Report Inappropriate
Answer should contain a minimum of 25 characters.
Programming
Databases
PostgreSQL
عقبة بلخيري's image
Question added by عقبة بلخيري Ingénieur d'état en Informatique Administration
8 years ago

Why it is preferred to create a table space on a partition other than the system partition?‎

Answers:
2
Followers:
Views:
66
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Open Source
PostgreSQL
PHP
ASP.NET
Zaid Rabab'a's image
Question added by Zaid Rabab'a Software Development Team Leader Al-Safa Co. Ltd.
11 years ago

How to get last three month records from a table? ‎

Postgresl / mySQL / Oracle‎

Answers:
11
Followers:
Views:
629
Vote Count:
5
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
PostgreSQL
SQL
Software Engineering
Yii
Default profile image
Question added by Deleted user
10 years ago

How can I get the value for aggregate query in Yii if the aggregate value not an attribute on the activerecord class?‎

$criteria = new CDbCriteria(); $criteria->select = 'type , seen, count(1) As counts'; $criteria->condition = 'mb = :mb AND deleted = false AND arc‎ ... See More

Answers:
1
Followers:
Views:
1506
Vote Count:
4
Report Inappropriate
Answer should contain a minimum of 25 characters.
MySQL
PostgreSQL
SQL
Access
Oracle
Default profile image
Question added by Deleted user
10 years ago

What are the differences between Oracle , MSSql , MySql , Access and postgresql, please compare by the following points ?‎

Points are : (1) - number of the computers ( clients ) that I can Connect To that database (2) - security that make that database special (3) - command that help to make ‎ ... See More

Answers:
4
Followers:
Views:
1984
Vote Count:
3
Report Inappropriate
Answer should contain a minimum of 25 characters.
Databases
PostgreSQL
Database Management
CouchDB
Database
Shagufta Mubasher's image
Question added by Shagufta Mubasher Web Developer MP CJ O Shopping Sdn. Bhd.
10 years ago

What do you mean by NOSQL database?‎

Explain with illustrations/examples‎

Answers:
3
Followers:
Views:
152
Vote Count:
2
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Databases
PostgreSQL
Oracle
Software Engineering
Zaid Rabab'a's image
Question added by Zaid Rabab'a Software Development Team Leader Al-Safa Co. Ltd.
11 years ago

What database aspects should be monitored?‎

Answers:
2
Followers:
Views:
139
Vote Count:
4
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Open Source
PostgreSQL
Oracle
Software Engineering
Zaid Rabab'a's image
Question added by Zaid Rabab'a Software Development Team Leader Al-Safa Co. Ltd.
11 years ago

What database block size should I use?‎

Answers:
3
Followers:
Views:
330
Vote Count:
4
Report Inappropriate
Answer should contain a minimum of 25 characters.
Programming
PostgreSQL
SQL
Computer Science
Database
Default profile image
Question added by Deleted user
9 years ago

How to perform the Delete dml in postgres and get the number of deleted rows at the same time?‎

Answers:
1
Followers:
Views:
130
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.