    WHERE workorder.createdtime &gt; current_date - 1     -- Yesterday and today

    WHERE workorder.createdtime &gt; current_timestamp - interval &#39;1 day&#39; -- last 24hr

# `&gt; TIMESTAMP &#39;yesterday&#39; `

For convenience, Postgres includes a few hard-coded values as [special Date/Time inputs][1]. They include:

 - `yesterday`
 - `today`
 - `tomorrow`
 - `now`

Try `SELECT TIMESTAMP &#39;now&#39;`.

For example, here is a query.

&lt;!-- language: lang-sql --&gt;

    SELECT when_row_created_
    FROM customer_
    WHERE when_row_created_ &gt; TIMESTAMP &#39;yesterday&#39; 
    ORDER BY when_row_created_ DESC
    ;

These commands may not be appropriate to production code, but they certainly are handy in development. Read the docs and do some practice to be sure you understand the behavior of these commands, how the session’s time zone affects them and so on. 

Downsides include (a) implicitly ignoring the crucial issue of time zone, and (b) not standard SQL. 

  [1]: http://www.postgresql.org/docs/current/static/datatype-datetime.html#AEN6039

    where workorder.createdtime &gt;= now() - interval &#39;24 hour&#39; 

    WHERE workorder.createdtime::date = current_date - 1; --from yesterday

i&#39;m trying to make my two elements toggle, so if one element is clicked it will remove all references of my-class and apply it to its self. Any ideas?

    &lt;span id=&quot;1&quot; ng-style=&quot;my-class&quot; ng-click=&quot;tog=my-class&quot;&gt;&lt;/span&gt;

    &lt;span id=&quot;2&quot; ng-style=&quot;my-class&quot; ng-click=&quot;tog=my-class&quot;&gt;&lt;/span&gt;

Cheers!

Angular.js How to change an elements css class on click and to remove all others

I am trying to relearn C++ after taking an intro course a few years ago and I’m having some basic problems. My current problem occurs when trying to use a friend function. Here is my code in 2 files.

First:

    // fun.cpp
    
    #include &lt;iostream&gt;
    using namespace std;

    class classA {
    	friend void funct();
    public:
    	classA(int a=1,int b=2):propa(a),propb(b){cout&lt;&lt;&quot;constructor\n&quot;;}
    private:
    	int propa;
    	int propb;
    	void outfun(){
    		cout&lt;&lt;&quot;propa=&quot;&lt;&lt;propa&lt;&lt;endl&lt;&lt;&quot;propb=&quot;&lt;&lt;propb&lt;&lt;endl;
    	}
    };
    void funct(){                     // ERROR HERE
    	cout&lt;&lt;&quot;enter funct&quot;&lt;&lt;endl;
    	classA tmp(1,2);
    	tmp.outfun();
    	cout&lt;&lt;&quot;exit funct&quot;&lt;&lt;endl;
    }

Second:

    // mainfile.cpp
    #include &lt;iostream&gt;
    #include &quot;fun.cpp&quot;
    using namespace std;
    
    int main(int nargin,char* varargin[]) {
    	cout&lt;&lt;&quot;call funct&quot;&lt;&lt;endl;
    	funct();
    	cout&lt;&lt;&quot;exit main&quot;&lt;&lt;endl;
    	return 0;
    }

The error I am getting is &quot;multiple definition of `funct()&#39;&quot;. Am I using the wrong syntax when declaring it as a friend function?

Error with multiple definitions of function

I have an application in which I&#39;ve used MySQL. I had a report that stretched records of the last 24 hours. I used the query:


    WHERE (DATE_SUB(CURDATE(), INTERVAL 1 DAY) &lt;= FROM_UNIXTIME(`workorder`.`CREATEDTIME` / 1000))


Now I have to use PostgreSQL and do not know how to make a report of the last 24 hours.
Can any of you help?


records from yesterday in postrgesql

I have an application in which I've used MySQL. I had a report that stretched records of the last 24 hours. I used the query:
<pre><code class="hljs language-scss">WHERE (DATE_SUB(CURDATE(), INTERVAL 1 DAY) &#x3C;= FROM_UNIXTIME(`workorder`.`CREATEDTIME` / 1000))
</code></pre>
Now I have to use PostgreSQL and do not know how to make a report of the last 24 hours.
Can any of you help?

A password is visible in my psql prompt (by pushing up arrow to view previous inputted commands). So I would like to delete that entry from the psql client. 

Other resources([1], [2]) claim that psql client history is kept in is a `~/.psql_history` file, however this file is simply not there. (it&#39;s not in `.bash_history` either)

So **there must be another file where the history of psql prompt is kept, any ideas where?**

I log in to my prompt like this 
`sudo -u postgres psql my_db`

Note: I am working on `Ubuntu 12.04`


  [1]: http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/
  [2]: https://stackoverflow.com/questions/6654121/postgresql-psql-history-to-dev-null

Where is psql client history kept? (~/.psql_history non-existent!)

Having a bit of an issue with PostgreSQL on Mac OS X 10.8.4. I accidentally did `brew rm postgresql --force` while the postgres server was running. When I installed using `brew install postgresql` and ran `pg_ctl -D /usr/local/var/postgres start` I get:

    pg_ctl: another server might be running; trying to start server anyway
    server starting
    FATAL:  lock file &quot;postmaster.pid&quot; already exists                                                                       
    HINT:  Is another postmaster (PID 752) running in data directory &quot;/usr/local/var/postgres&quot;?

when I run &quot;ps -ef | grep postgres&quot; I get:

    501   752   235   0 12:42PM ??         0:00.01 /usr/local/opt/postgresql/bin/postgres -D /usr/local/var/postgres -r /usr/local/var/postgres/server.log
    501   754   752   0 12:42PM ??         0:00.00 postgres: checkpointer process       
    501   755   752   0 12:42PM ??         0:00.34 postgres: writer process       
    501   756   752   0 12:42PM ??         0:00.02 postgres: wal writer process       
    501   757   752   0 12:42PM ??         0:00.01 postgres: autovacuum launcher process       
    501   758   752   0 12:42PM ??         0:00.01 postgres: stats collector process       
    501   945   452   0 12:58PM ttys000    0:00.00 grep postgres

when I try to stop the server with `pg_ctl stop -D /usr/local/var/postgres -m fast` or `pg_ctl -D /usr/local/var/postgres stop -mi` I get: 


    waiting for server to shut down........................................... Failed
    pg_ctl: server does not shut down

**EDIT**

    which pg_ctl
    /usr/local/bin/pg_ctl
    pg_ctl --version
    pg_ctl (PostgreSQL) 9.2.4

Gist of `server.log`: https://gist.github.com/anonymous/6106182


PostgreSQL server won&#39;t stop

I&#39;m using PostgreSql version : 

    postgres=# select version();
                               version
    -------------------------------------------------------------
     PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit
    (1 row)


i had connected to a database from `postgres=#` to `newdb=#`....
Now i&#39;m in `newdb=#` Database i want to disconnect it and go back to `postgres=#` database ....

How to do this ?


I have tried with `disconnect newdb;`

but its giving erroe as::

    postgres=# create database newdb;
    CREATE DATABASE
    postgres=# \c newdb;
    WARNING: Console code page (437) differs from Windows code page (1252)
             8-bit characters might not work correctly. See psql reference
             page &quot;Notes for Windows users&quot; for details.
    You are now connected to database &quot;newdb&quot; as user &quot;postgres&quot;.
    newdb=# disconnect newdb;
    ERROR:  syntax error at or near &quot;disconnect&quot;
    LINE 1: disconnect newdb;
            ^
    newdb=#


it isnt working is there any other way to do this or am i wrong in anything!!

How to Disconnect from a database and go back to the default database in PostgreSQL?

database.yml:

    # SQLite version 3.x
    #   gem install sqlite3
    #
    #   Ensure the SQLite 3 gem is defined in your Gemfile
    #   gem &#39;sqlite3&#39;
    development:
      adapter: postgresql
      encoding: utf8
      database: sampleapp_dev  #can be anything unique
      #host: localhost
      #username: 7stud
      #password: 

      #adapter: sqlite3
      #database: db/development.sqlite3
      pool: 5
      timeout: 5000
    
    # Warning: The database defined as &quot;test&quot; will be erased and
    # re-generated from your development database when you run &quot;rake&quot;.
    # Do not set this db to the same as development or production.
    test:
      adapter: postgresql
      encoding: utf8
      database: sampleapp_test  #can be anything unique
      #host: localhost
      #username: 7stud
      #password: 
      #adapter: sqlite3
      #database: db/test.sqlite3
      pool: 5
      timeout: 5000
    
    production:
      adapter: postgresql
      database: sampleapp_prod   #can be anything unique
      #host: localhost
      #username: 7stud
      #password: 
      #adapter: sqlite3
      #database: db/production.sqlite3
      pool: 5
      timeout: 5000


pg_hba.conf:

    # TYPE  DATABASE        USER            ADDRESS                 METHOD
    
    # &quot;local&quot; is for Unix domain socket connections only
    local   all             all                                     trust
    # IPv4 local connections:
    host    all             all             127.0.0.1/32            trust
    # IPv6 local connections:
    host    all             all             ::1/128                 trust
    # Allow replication connections from localhost, by a user with the
    # replication privilege.
    #local   replication     postgres                                md5
    #host    replication     postgres        127.0.0.1/32            md5
    #host    replication     postgres        ::1/128                 md5

I changed the METHOD in the first three lines from md5 to trust, but I still get the error.

And no matter what combinations of things I try in database.yml, when I do:

    ~/rails_projects/sample_app4_0$ bundle exec rake db:create:all

I always get the error:

&gt; fe_sendauth: no password supplied


I followed this tutorial to get things setup:

https://pragtob.wordpress.com/2012/09/12/setting-up-postgresql-for-ruby-on-rails-on-linux


    Mac OSX 10.6.8
    PostgreSQL 9.2.4 installed via enterpriseDB installer
    Install dir: /Library/PostgreSQL/9.2

fe_sendauth: no password supplied

Now I&#39;ve found a lot of similar SO questions including an old one of mine, but what I&#39;m trying to do is get any record older than 30 days but my table field is unix_timestamp. All other examples seem to use DateTime fields or something. Tried some and couldn&#39;t get them to work.

This definitely doesn&#39;t work below. Also I don&#39;t want a date between a between date, I want all records after 30 days from a unix timestamp stored in the database. 
I&#39;m trying to prune inactive users.

simple examples.. doesn&#39;t work. 

    SELECT * from profiles WHERE last_login &lt; UNIX_TIMESTAMP(NOW(), INTERVAL 30 DAY)  

And tried this

    SELECT * from profiles WHERE UNIX_TIMESTAMP(last_login - INTERVAL 30 DAY) 

Not too strong at complex date queries. Any help is appreciate. 

Content Type	Original Author	Original Content on Stackoverflow
Question	Krokodyle	View Question on Stackoverflow
Solution 1 - Postgresql	Curt	View Answer on Stackoverflow
Solution 2 - Postgresql	Basil Bourque	View Answer on Stackoverflow
Solution 3 - Postgresql	Roman Pekar	View Answer on Stackoverflow
Solution 4 - Postgresql	Lucky Ratnawat	View Answer on Stackoverflow

records from yesterday in postrgesql

Postgresql Problem Overview

Postgresql Solutions

Solution 1 - Postgresql

Solution 2 - Postgresql

`> TIMESTAMP 'yesterday'`

Solution 3 - Postgresql

Solution 4 - Postgresql

Error with multiple definitions of function

Angular.js How to change an elements css class on click and to remove all others

Attributions