Mark W's SQL Blog

Opinions, experiences and information about SQL and the databases that process it, from a guy who's been at it for over 20 years.

Friday, November 23, 2018

Happy Fibonacci Day!

Happy Fibonacci day, here is how to generate a Fibonacci sequence in PostgreSQL
on November 23, 2018
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Pages

  • Home
  • Privacy Policy
  • Cookie Policy

About Me

My photo
MWrynn
DBA/Developer working with a slew of databases, but most passionate about Postgres and Oracle. Big proponent of maximizing your database investment by taking advantage of the powerful features it has to offer. Big opponent of using your database as a generic, lowest common denominator bit bucket.
View my complete profile

Blog Archive

  • ►  2024 (5)
    • ►  December (2)
    • ►  September (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2023 (4)
    • ►  November (4)
  • ►  2021 (1)
    • ►  May (1)
  • ►  2020 (3)
    • ►  August (2)
    • ►  January (1)
  • ►  2019 (9)
    • ►  October (1)
    • ►  June (4)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2018 (12)
    • ►  December (1)
    • ▼  November (1)
      • Happy Fibonacci Day!
    • ►  October (1)
    • ►  September (3)
    • ►  August (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2017 (6)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
  • ►  2016 (17)
    • ►  November (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (1)
    • ►  April (2)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  December (1)
    • ►  May (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2014 (8)
    • ►  September (1)
    • ►  August (2)
    • ►  March (3)
    • ►  February (2)
  • ►  2013 (12)
    • ►  December (1)
    • ►  November (3)
    • ►  September (2)
    • ►  August (2)
    • ►  April (1)
    • ►  March (3)
  • ►  2012 (4)
    • ►  August (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2011 (24)
    • ►  December (1)
    • ►  November (3)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (3)
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (2)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2009 (2)
    • ►  December (1)
    • ►  March (1)
  • ►  2008 (1)
    • ►  December (1)
  • ►  2007 (6)
    • ►  July (2)
    • ►  May (1)
    • ►  April (3)

Labels

  • 10
  • 11g
  • 12c
  • 12cR2
  • add column
  • alert log
  • Amazon
  • analytics
  • apgdiff
  • api
  • argh
  • AskTom
  • auditing
  • awesome
  • AWS
  • big data
  • bind
  • bind variables
  • bonkers
  • BoobyTrap
  • Books
  • bug
  • caching
  • cartoon
  • cern
  • character sets
  • chat
  • clone
  • cluster
  • clustered
  • clustering
  • collations
  • column
  • column store
  • columns diffs
  • common table expressions
  • comparison
  • connor mcdonald
  • crazy
  • CTE
  • CTEs
  • danger
  • database of the year
  • db-engines
  • db2
  • ddl
  • default
  • diff
  • distinct on
  • dynamic columns
  • EC2
  • emacs
  • errors
  • evil
  • Evil MySQL Feature
  • example
  • expdp
  • export
  • features
  • foreign keys
  • game
  • generate series
  • generation
  • history
  • IGNORE
  • impdp
  • import
  • in
  • incremental refresh
  • independence
  • index
  • indexes
  • inheritance
  • INSERT IGNORE
  • installation
  • Java
  • JDBC
  • join
  • joins
  • JOOQ
  • JSON
  • just bind
  • key-value
  • length
  • limitation
  • linux
  • lisp
  • load balancing
  • locking
  • locks
  • logging
  • lol
  • mandelbrot
  • maria
  • mariadb
  • MATCH_RECOGNIZE
  • materialized views
  • merge
  • microsoft
  • missing comma
  • MODIFY
  • MS SQL
  • MSSQL
  • mwrynn
  • MySQL
  • MySQL.com
  • newlines
  • News
  • numeric
  • odd
  • online recovery
  • optimization
  • optimizations
  • optional
  • oracle
  • parallel
  • parameter
  • parameterization
  • parameters
  • paramterization
  • partitioned aggregates
  • partitioning
  • performance
  • pgpool
  • pgpool-ii
  • pi
  • pi day
  • pivot
  • pl/sql
  • postgres
  • postgresql
  • preparedstatement
  • query
  • query rewrite
  • quiz
  • r/sql
  • random
  • rant
  • RDS
  • recovery
  • recursive
  • recursive query
  • reddit
  • reference
  • refresh
  • release
  • REPLACE
  • REPLACE INTO
  • reporting
  • retrosheet
  • rewrite
  • row pattern matching
  • schema
  • scripts
  • sequences
  • series
  • shared memory
  • shmmax
  • sparkfun
  • speed
  • SQL
  • SQL injection
  • SQL Server
  • sqlplus
  • sucks
  • Sybase
  • syntax
  • table
  • test
  • Tom Kyte
  • trick
  • unpivot
  • upgrade
  • upgrading
  • upsert
  • usebindvariables
  • version
  • versioning
  • weird
  • whygod
  • window
  • window functions
  • windowing
  • with
  • with recursive
  • wonky

Report Abuse

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Followers

Search This Blog

Evil MySQL Feature: REPLACE INTO

Popular Posts

  • Postgres trick: Referring to columns dynamically within static SQL
    The goal in this demo is to refer to columns dynamically, without the help of some other language dynamically generating SQL. This is so we ...
  • Pgpool-II Load Balancing
    I've been trying, so far unsuccessfully, to get load balancing working in a pgpool-II replication environment with two nodes. This is su...
  • Postgres query using window functions, recursive query
    As Tom Kyte says, " Analytics rock. Analytics roll. " Among other things, Oracle's analytic queries allow a row in the results...
Watermark theme. Powered by Blogger.